WorksheetsPrior Knowledge
Total questions: 5
Worksheet time: 3mins
Name
Class
Date
1.
Which function is used to calculate the total of a range of numbers in a spreadsheet?
a)
AVERAGE
b)
MIN
c)
MAX
d)
SUM
2.
What does the error message #DIV/0! indicate in a spreadsheet?
a)
A number is being divided by zero
b)
A cell contains text instead of a number
c)
A formula is missing a closing bracket
d)
The cell reference is invalid
3.
Which function returns the highest value in a selected range?
a)
COUNT
b)
MAX
c)
MIN
d)
AVERAGE
4.
What is the purpose of cell formatting in spreadsheets?
a)
To change the formula used in a cell
b)
To make the spreadsheet calculate faster
c)
To improve readability and presentation
d)
To prevent errors in formulas
5.
Which function calculates the average of a range of numbers?
MAX
COUNT
AVERAGE
SUM
a)
MAX
b)
COUNT
c)
AVERAGE
d)
SUM
100 %
