Mastering Excel 2019 – Advanced

Mastering Excel 2019 – Advanced

Time limit: 0

Quiz Summary

0 of 17 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 17 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

Current
Review
Answered
Correct
Incorrect

Question 1 of 17

1. Question

A cell can be linked to another cell to show the same data in two places. What is the main reason you would do this?

So that multiple people can view the same data at one time

To enter data once and only have to update it in one place

To maintain consistent formatting across worksheets

Correct

Incorrect
Question 2 of 17

2. Question

What feature allows you to copy and paste the results of a formula rather than the formula itself?

Paste Values

Transpose

Paste Link

Correct

Incorrect
Question 3 of 17

3. Question

How can you enter group mode in which you can modify multiple worksheets in the same way at the same time?

Right-click on any sheet and choose "Select All Sheets"

Use Ctrl or Shift to manually select multiple sheets

Go to the Data tab and select "Group Mode"

A or B

Correct

Incorrect
Question 4 of 17

4. Question

What visual indicator appears to show you a comment has been added to a cell?

The cell has a text box over it

The cell has a light purple background

The cell has a purple triangle in the top-right corner

It's not possible to see if a cell has an added comment

Correct

Incorrect
Question 5 of 17

5. Question

Which of the following is not a recommended consideration for the accessibility of your worksheet?

Use clear description for column and row headers

Only use black and white images

Eliminate blank rows, columns, and cells in your data

Add alternative text to images and other objects

Correct

Incorrect
Question 6 of 17

6. Question

If you encrypt your Excel workbook and you forget the password, you can contact your IT department to reset the password.

True

False

Correct

Incorrect
Question 7 of 17

7. Question

What feature allows you to specify the accepted values that can be inserted into a cell?

Data Validation

Manage Data Model

Flash Fill

Conditional Formatting

Correct

Incorrect
Question 8 of 17

8. Question

Which of the following is NOT a limitation of the VLOOKUP function?

The lookup value must be in the first column of the table array

VLOOKUP is only available in Excel Online

VLOOKUP does not look for duplicate values and only returns the first match it finds

Correct

Incorrect
Question 9 of 17

9. Question

Which function tells you the location of a value within a range?

MATCH

INDEX

HLOOKUP

LOOKUP

Correct

Incorrect
Question 10 of 17

10. Question

What is the purpose of cell tracing (e.g., Trace Error, Trace Precedents, Trace Dependents)?

To view a history of changes to a cell

To determine if the contents of a cell have moved up or down in your worksheet

To graphically view the relationships among cells in order to understand exactly which cells impact other cells

To trace a border around a cell for emphasis

Correct

Incorrect
Question 11 of 17

11. Question

The IFNA and IFERROR functions are examples of what best practice?

Error handling

Clean formula writing

Error minimizing

Error tracing

Correct

Incorrect
Question 12 of 17

12. Question

What is the purpose of Goal Seek in What-If Analysis?

To determine the input value you need in order for the formula to get a specific result

To examine data trends to estimate productivity for the next quarter

To look at multiple hypothetical outcomes by changing more than one value within a formula

None of the above

Correct

Incorrect
Question 13 of 17

13. Question

What is the purpose of the Solver add-in?

To determine a solution with a maximum of one constraint

To determine the value of a specific input to arrive at a predetermined outcome

To create a data table of solutions for multiple inputs

To determine a solution that satisfies multiple parameters and constraints

Correct

Incorrect
Question 14 of 17

14. Question

Which of the following is NOT a key consideration for using map charts?

You should use common geographic codes that Excel can recognize

You must be online

You should add more information when possible-like a country code when you're displaying information for states or provinces

You must first import a map of the countries you wish to use on your map chart

Correct

Incorrect
Question 15 of 17

15. Question

If your open a text file from inside Excel, the app will open the Text Import Wizard. Within this wizard, what is a delimiter?

A character that indicates the end of the text file

A character that indicates the boundary between fields

A character that indicates the end of each row

Correct

Incorrect
Question 16 of 17

16. Question

What is the general term for objects you insert onto a custom form (e.g., list box, combo box, checkbox)?

Form Objects

Form Modules

Form Boxes

Form Controls

Correct

Incorrect
Question 17 of 17

17. Question

Why would you choose to use ActiveX controls in your forms as opposed to regular form controls?

To protect your workbooks from viruses

When you're creating Visual Basic (VB) forms

When you want your forms to be more accessible

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.