Mastering Excel 2019 – Basics

Mastering Excel 2019 – Basics

Time limit: 0

Quiz Summary

0 of 18 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 18 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

Current
Review
Answered
Correct
Incorrect

Question 1 of 18

1. Question

What does the data range A2:L15 refer to?

The rectangle of cells from row A to L and column 2 to 15

The rectangle of cells from columns A to L and rows 2 to 15

The rectangle of cells from row A2 to column L15

Correct

Incorrect
Question 2 of 18

2. Question

Which of the following will enter data into a cell after you’ve typed it?

Press the Enter key

Press the Tab key

Click the green checkmark on the Formula Bar

All of the above

Correct

Incorrect
Question 3 of 18

3. Question

What symbol is used to start a formula?

= (equal sign)

* (asterisk)

> (greater than)

! (exclamation point)

Correct

Incorrect
Question 4 of 18

4. Question

Why would you choose to make a cell reference absolute?

To ensure the cell reference changes when you copy it

To keep Excel from copying the cell reference

To format the number as currency

To keep Excel from changing the reference when you copy it

Correct

Incorrect
Question 5 of 18

5. Question

What is it called when either the column or row in a cell reference is absolute, and the other is relative?

A half reference

A mixed reference

A partial reference

Correct

Incorrect
Question 6 of 18

6. Question

What happens if you double-click the border separating the column letters (for example the line between the A and B column headings)?

Nothing

The A column is hidden

The B column expands to a width of 17

The A column autofits the width to fit the data in the column

Correct

Incorrect
Question 7 of 18

7. Question

Which of the following is NOT true about the Find feature?

You can only search one worksheet at a time

You can search for text and formatting

You can search for part of a word

You can search for all occurrences of an entry

Correct

Incorrect
Question 8 of 18

8. Question

What does the Format Painter tool do?

Pastes formulas into other cells

Copies and pastes formatting to other cells

Paints a cell in the color that was last used

Correct

Incorrect
Question 9 of 18

9. Question

Formatting applies to cells, not data.

True

False

Correct

Incorrect
Question 10 of 18

10. Question

What command allows text to move onto two or more lines within a cell?

Multiple Line Text

Continuous Text

Wrap Text

Correct

Incorrect
Question 11 of 18

11. Question

What is the purpose of conditional formatting?

To identify when the contents of a cell meet specified criteria

To identify which cells in your worksheet contain errors

To limit which cells in a worksheet can be formatted

Correct

Incorrect
Question 12 of 18

12. Question

Which commands allows you to set exactly which cells to print?

Select Print Cells

Print Only Cells

Set Print Arena

Set Print Area

Correct

Incorrect
Question 13 of 18

13. Question

Why would you use the Print Titles command?

To print headings on page 1

To repeat specific columns or rows on every printed page

To customize headers and footers

To set the print area

Correct

Incorrect
Question 14 of 18

14. Question

What action lets you rename a worksheet?

Double-clicking on the sheet name

Right-clicking on the sheet name and selecting "Rename"

Clicking and holding on the sheet name until the name highlights

A and B

Correct

Incorrect
Question 15 of 18

15. Question

What feature allows you to save a set of display and print settings so you can quickly apply them when needed?

Personal View

Custom View

Saved View

My View

Correct

Incorrect
Question 16 of 18

16. Question

Why might you choose to use the Freeze Panes command?

To prevent others from changing the data

To keep specific rows or columns in place on the screen when scrolling

To get a snapshot of the spreadsheet at a specific data and time

None of the above

Correct

Incorrect
Question 17 of 18

17. Question

Where would you find Workbook Properties in Backstage View?

Info

Open

Export

Correct

Incorrect
Question 18 of 18

18. Question

What is the name of the area at the top-left corner where you can customize a set of commands for easy access?

Easy Access Toolbar

Fast Access Toolbar

Quick Access Toolbar

Quick Access Ribbon

Correct

Incorrect

ATS eLearning

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.