WorksheetsExcel Functions Quiz
Total questions: 20
Worksheet time: 10mins
What does the SUM function do in Excel?
Adds all numbers in a selected range
Finds the largest number in a range
Finds the smallest number in a range
Counts the number of cells
Which function is used to find the highest value in a range?
AVERAGE()
MAX()
MIN()
COUNT()
What does the MIN function return?
The total of all numbers in a range
The highest number in a range
The lowest number in a range
The average of a range
What is the purpose of the AVERAGE function in Excel?
Finds the highest value in a range
Finds the lowest value in a range
Finds the sum of numbers in a range
Finds the mean of numbers in a range
Which of the following is a correct formula to get the sum of cells A1 to A10?
=ADD(A1:A10)
=SUM(A1:A10)
=TOTAL(A1:A10)
=COUNT(A1:A10)
If you enter =MAX(4, 8, 2, 10, 5), what will be the result?
2
4
10
8
What will =MIN(12, 7, 19, 5, 10) return?
12
7
5
10
What does =AVERAGE(5,10,15,20,25) return?
10
15
20
25
What is an absolute reference in Excel?
A reference that changes when copied to another cell
A reference that remains fixed when copied
A reference that only applies to formulas
A reference that calculates absolute values
How do you make a cell reference absolute in Excel?
Add $ before the column and row (e.g., $A$1)
Add # before the cell address (e.g., #A1)
Use ABS(A1)
Type the reference in bold
If cell A1 contains 10 and B1 contains 5, what will =A1 + $B$1 return if copied to C2?
15
10
5
Error
If =SUM(A1:A5 * B1:B5) is used, what error will it return?
#VALUE!
#NAME?
#REF!
#DIV/0!
Which function will return the highest number from cells A1 to A10?
=SUM(A1:A10)
=MAX(A1:A10)
=AVERAGE(A1:A10)
=COUNT(A1:A10)
If =SUM(A1:A5) + AVERAGE(B1:B5) is used, what is calculated?
The sum of A1 to A5 and the average of B1 to B5
The sum of both ranges
The highest value in both ranges
The lowest value in both ranges
If =AVERAGE(A1:A5, B1:B5) is used, what does it do?
Finds the average of A1:A5
Finds the average of B1:B5
Finds the combined average of both ranges
Adds both ranges
Which of the following is NOT a correct use of the SUM function?
=SUM(A1:A5)
=SUM(A1, A2, A3)
=SUM(A1:A5, B1:B5)
=SUM(A1 to A5)
If A1 = 100, A2 = 200, and A3 = 300, what is the result of =AVERAGE(A1:A3)?
100
200
300
600
If you type =SUM(A1:A5, B1:B5, C1:C5), what will it return?
The sum of all numbers in A1:A5
The sum of all numbers in A1:A5 and B1:B5
The sum of numbers from A1:A5, B1:B5, and C1:C5
The average of all values
What happens if you use =MAX(A1:A5) - MIN(A1:A5)?
It returns the sum of the highest and lowest values
It returns the range (difference between the highest and lowest value)
It returns the total sum of the values
It returns an error
If you want to calculate the total sales from January to December in column B, which formula should you use?
=SUM(B1:B12)
=AVERAGE(B1:B12)
=MAX(B1:B12)
=MIN(B1:B12)
