Font size
WorksheetsExcel Functions
Total questions: 16
Worksheet time: 8mins
What is the purpose of the MIN function?
Add the numerical values in a range of cells
Find the lowest number in a range of cells
Find the highest number in the range of cells
Finds the average from a range of cells
All functions and formulas begin with which symbol?
#
/
:
=
Which are the three essential elements to enter a function?
Equal sign, function name, and cell reference.
Equal sign, cell reference, and formula.
Function name, data, and cell reference.
Function name and cell reference.
Which function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?
Count
Count A
If
Sum
What is the result of =C4 + C5
32
12
17
15
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
Which function would display "Yes" if D13 is greater than 0?
=IF(D13>0, "Yes", "No")
=IF(D13<0, "Yes", "No")
=IF(D13>0: "Yes", "No")
=IF(D13<0: "Yes", "No")
What is the purpose of the MAX function?
Add the numerical values in a range of cells.
Find the lowest number in a range of cells.
Find the highest number in the range of cells.
Finds the average from a range of cells.
Is the following a valid function?
=SUM(12+56)
Yes
No
SUM, AVERAGE and COUNT are all known as spreadsheet:
formula
data
functions
graphs
Which of the following is an example of a range?
D3
D3 and D5
D3:D18
Sum
Use the spreadsheet you created, see the sample in the image. Which function calculates the total for score 1?
=Total(B2:B4)
=Sum(B2:B4)
=Sum(C2:C4)
=Total(C2:C4)
Use the spreadsheet you created, see sample in image. Type the CORRECT function that calculates the average for score 1?
(a)
