NEW
Font size
WorksheetsCPA Excel Revision Quiz
Total questions: 16
Worksheet time: 5mins
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)
Identify the formula that calculates the Highest Sales in cell C12.
=Max(C4:C10)
=Min(C4:C10)
=Total(C4:C10)
=Average(C4:C10)
Identify the formula that calculates the Lowest Sales in cell D13.
=Max(D4:D10)
=Min(D4:D10)
=Sum(D4:D10)
=Average(D4:D10)
The diagram below shows a spreadsheet. Which range of cells contains a formula?
B2:B5
C2:C5
E2:E5
F2:F5
Which of the following charts would best show the sales trend of all the candies?
column chart
line chart
pie chart
scatter plot
Which is a likely formula shown in cell E3?
= Sum(B3:D3)
= Sum(B3:B5)
= Sum(E3:E5)
=195
To draw a pie chart to show how each type of candy contributes to 1st quarter sales, which range of cells would you highlight?
E3:E5
E3:E6
B6:D6
B6:E6
