CPA Excel Revision Quiz

Study the table below and identify the highlighted cells.

• B3:E4

• B4:E3

• E3:B4

• E4:B3

The formula used under the ‘Total’ column is ______________.

• AVERAGE

• MAX

• MIN

• SUM

When #### is displayed in a cell of a spreadsheet, it means that the _______________.

• cell is not valid

• cell width is too narrow

• wrong operator is used

• formula has been entered incorrectly

Use the spreadsheet table below, how many rows and columns are shown above?

• 7 columns and 3 columns

• 7 rows and 3 columns

• 8 columns and 4 rows

• 8 rows and 4 columns

Which cell shows the class of Captain Hook?

• B5

• C1

• C5

• D5

What is the range of cells selected?

• B2:C4

• B1:C3

• C4:B2

• C3:B1

Which range of cells contains formula?

• B11:D13

• A4:A10

• B4:D10

• B4: D13

What is the name of the movie title that is in the cell address A7.

• Spider-Man: Homecoming

• War for the Planet of the Apes

• Transformers: The Last Knight

• Despicable Me 3

Identify the range of cells that are right-aligned.

• A3:A10

• B4:D13

• A11:A13

• A1:D1

Identify the formula that calculates the Average Sales in cell B11.

• =Average(B4:B10)

• =Sum(B4:B10)

• =Max(B4:B10)

• =Min(B4:B10)