Mastering Excel 365 – Advanced

Mastering Excel 365 – Advanced

Time limit: 0

Quiz Summary

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

Current
Review
Answered
Correct
Incorrect

Question 1 of 14

1. Question

If you open a text file from inside Excel, the app will open the Text Import Wizard. What does the Text Import Wizard do?

Hides certain data to make it "invisible" to unauthorized viewers

Examines the file you are importing to help ensure the data is imported correctly

Indicates the end of each row for each itemized character

Restores the dialog box to its rightful place

Correct

Incorrect
Question 2 of 14

2. Question

When you use a template in Excel, you are actually modifying the original template.

True

False

Correct

Incorrect
Question 3 of 14

3. Question

Which of the following is NOT a function that has dynamic array capability?

ALT

FILTER

SORT

SORTBY

Correct

Incorrect
Question 4 of 14

4. Question

Which of the following is true about the VLOOKUP function?

VLOOKUP can't look up data in a table

VLOOKUP can only be used to import data

VLOOKUP can only match data left to right

VLOOKUP is the same as XLOOKUP

Correct

Incorrect
Question 5 of 14

5. Question

Which function returns the relative position of an item within a single row or single column?

MATCH

INDEX

HLOOKUP

LOOKUP

Correct

Incorrect
Question 6 of 14

6. Question

What feature allows you to define restrictions on data entered into a cell?

Data Validation

Manage Data Model

Flash Fill

Conditional Formatting

Correct

Incorrect
Question 7 of 14

7. Question

Which error alert style will restrict invalid data from being entered into a cell?

Information

Stop

Warning

Both B and C

Correct

Incorrect
Question 8 of 14

8. Question

Up to how many levels of outlined data can you view in Excel?

4

6

7

8

Correct

Incorrect
Question 9 of 14

9. Question

Data consolidation summarizes data from separate ranges, consolidating the results into a single location.

True

False

Correct

Incorrect
Question 10 of 14

10. Question

What is the programming language Excel uses to record the Macro steps?

VBA

Java

Python

PHP

Correct

Incorrect
Question 11 of 14

11. Question

When would you use a dual axis chart?

When the data is primarily text

When you want to show increase over time

When you want the axis on the right hand side

When the values in a chart vary widely from data series to data series

Correct

Incorrect
Question 12 of 14

12. Question

What happens if you link a shape to a cell?

You get an IFERROR message

You can easily turn it into a 3-D model

Your Excel workbook also linked to the shape

The text on the shape will update if the cell data changes

Correct

Incorrect
Question 13 of 14

13. Question

When formatting graphics, what action do you take to copy the formatting multiple times?

Use the Compression option

Single-click the Format Painter

Double-click the Format Painter

Double-click the Reset button

Correct

Incorrect
Question 14 of 14

14. Question

What does the Accessibility Checker look for?

Content that makes the document difficult or impossible to read and understand

Mislabeled column and row headers

Unclear or offensive language

Alternative pictures to substitute for poor image quality

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.