NEW
Font size
WorksheetsSpreadsheet Functions Quiz
Total questions: 7
Worksheet time: 4mins
What is the purpose of the AutoSum button in the Home tab?
To calculate the average of selected cells automatically.
To apply the sum function automatically.
To find the maximum value in selected cells.
To sort the data in ascending order.
Which function can be used to calculate the average of selected cells?
SUM
AVERAGE
MIN
MAX
What does the "Least amount" function calculate in the spreadsheet?
The total of all values.
The smallest value in the selected range.
The average of all values.
The largest value in the selected range.
In the Students Heights spreadsheet, which function finds the tallest student?
MIN
MAX
AVERAGE
SUM
Which function finds the shortest student in the Students Heights spreadsheet?
MAX
SUM
MIN
AVERAGE
What is the result of applying the SUM function to a range of cells?
The average of the values in the range.
The total of the values in the range.
The smallest value in the range.
The largest value in the range.
What does the "Most of fruits" function calculate in the spreadsheet?
The total number of fruits.
The fruit with the highest amount.
The average price of fruits.
The fruit with the lowest amount.
