NEW
Font size
WorksheetsGetting to Know Spreadsheets 7.2 L6 End of Topic Quiz
Total questions: 11
Worksheet time: 22mins
What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?
+
=
-
*
Name a function that tells you the maximum value.
Maximus
MAX
MAXIMUM
Name a function that tells you the minimum value.
MIN
MINIMUM
MINUS
Name a function that tells you how many non-blank values there are.
MIN
MAX
COUNTIF
COUNTA
What would be the easiest way to total several values together?
=SUM(D1:D4)
=(D1+D2+D3+D4)
4+2+5+3+1
Can you give the cell references for each of the following range in cells row 15–20 in column A
B2:B7
A17:A16
A15:A20
Which is the correct IF formula?
=IF(D4=3, “Well Done”, “Try again”)
IF(D4, 3, “Well Done”, “Try again”)
=IF( “Well Done”, “Try again” D4=3,)
Which AVERAGE formula is correct?
=AVERAGE(D:D9)
AVERAGE(D4:D9)
=AVERAGE(D4:D9)
What is Data?
Data can be anything.
Data is facts and figures.
Data is just symbols.
What is a secondary source?
A secondary source is a source which you have found and may decide to use.
A secondary source is when you decide to carry out a survey.
A secondary source is the same as a primary source, except it looks prettier, like a chart.
What is conditional formatting?
This is when the spreadsheet moves the data to the correct place.
This is when the spreadsheet selects the cells it wants to highlight
This is when the spreadsheet highlights cells of a similar criteria.
