WorksheetsEXCEL REVISION
Total questions: 24
Worksheet time: 11mins
In Excel, the cell C3 contains the formula =$A$3/$B$3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=$A$3/$B$3
=$C$3
=$A$5/$B$5
=$B$5/$C$5
Looking at the image, using a formula, what would the contents of E4 be?
(a)
Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?
(a)
What will clicking on Filter do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
What will clicking on Sort A to Z do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
In the image, what type of chart is it?
(a)
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)
Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.
format cell
conditional formatting
fill color
magic cell
All formulas begin with a(n) _______________.
&
=
+
#
Study the table below and identify the highlighted cells.
B3:E4
B4:E3
E3:B4
E4:B3
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 range of cells contains formula?
B11:D13
A4:A10
B4:D10
B4: D13
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)
The key at the side of the chart is called
a decoder
a what is where
a legend
the axis
we must add these so that the person reading the chart can see the exact figures clearly
data labels
information labels
number labels
item labels
