Over a Decade of Serious Learning for Ambitious Minds. * 9.5 of 10 (over 18 k student survey results - 2020)

# Excel Intermediate Assessment / Quiz

Find out which level of training is best for you. Answer the below questions and check the answers at the bottom.

1. Where is the name box when you name a cell range?

A   Right of the formula bar

B  Left of the formula bar

C  Above the formula bar

D  Right click on the most left cell in the range

E  I don't know

2. If I copy the following formula: =B5+D5 down a cell (to the next row), the newly copied formula will be:

A   The same: =B5+D5.

B  You can’t copy formulas.

C  =B6+D6

D  I don’t know.

3. What does the use of a "\$" in a cell reference (formula bar) do?

A   Gives your results back in currency format

B  Gives your results back in accounting format

C  Creates a fixed array for your formula - makes cell reference absolute

D  Creates an array for when using multiple formulas for a single solution

E  I don't know

4. In a basic IF function, what is the order inside the parenthesis?

A   True, False, Criterion

B  True, Criterion, False

C  Criterion, True, False

D  True, False

E  I don't know

5. Can you add or subtract dates?

A Yes

B No

C I don't know

6. VLOOKUP function searches:

B  Vertically searches the first column of a table and returns specified data from the same row

C  Horizontally and vertically

D  Horizontally across a table’s column headings

E  I don't know

7. AND and OR Conditions can be used interchangeably?

A   True

B  False

C  I don't know

8. Naming a cell has the following benefit:

A   Makes cell reference absolute.

B  Can be used in a formula.

C  Creates a Go To using the Name Box drop-down.

D  All of the above.

E  I don’t know.

9.       PivotTable are used for:

A       Summarizing and analyzing large amounts of data

B       Only analyzing external data

C       Expanding summarized data

D       None of the above

10.     Must you have a PivotTable to create a PivotChart?

A       Yes

B      No

11.     When customizing popular functions, first:

A       Click the Help button

B       Click the Start button, then Prepare icon

C       Click the Start button, then Excel Options

D       None of the above

12.     Ghosted text behind the contents of a page is called:

A       Page borders

B       Page background

C       Watermark

D       I don’t know