WorksheetsSpreadsheet Basics Quiz
Total questions: 15
Worksheet time: 8mins
What is the purpose of a spreadsheet?
To send emails
To play games
To organize, analyze, and store data
To edit images
What is a workbook?
A single worksheet
A spreadsheet file containing one or more worksheets
A column in a spreadsheet
A formula bar
What is the intersection of a row and a column called?
Range
Cell
Label
Value
Which of the following is a cell address?
Name
=SUM(A1:A5)
A1
50
Which of the following is a range?
A1
A1:B5
SUM
IF
A label in a spreadsheet is:
A number used in calculations
Text or non-numeric data
A built-in function
A cell address
What does the function =SUM(A1:A5) do?
Finds the average
Adds all numbers in cells A1 to A5
Finds the maximum
Counts the numbers
Which function calculates the average of values in a range?
SUM
DATE
AVERAGE
MIN
Which function would you use to return the highest number in a range?
MIN
MAX
COUNT
IF
What does COUNT(E1:E10) return?
Number of empty cells
Number of numeric cells
Total of all numbers
Largest number
Which function counts all non-empty cells?
COUNTIF
SUM
COUNTA
VLOOKUP
Which function is used to search for a value in the first column and return related data?
IF
DATE
VLOOKUP
PMT
Which function would you use to calculate loan payments?
IF
PMT
SUM
COUNT
Which formula would return “Pass” if a student scored 60, otherwise “Fail”?
=SUM(A1:A5)
=IF(A1>=50,"Pass","Fail")
=AVERAGE(A1:A5)
=COUNT(A1:A5)
Which of the following is NOT a spreadsheet function?
SUM
VLOOKUP
IF
