WorksheetsSpreadsheet Quiz
Total questions: 8
Worksheet time: 4mins
What is the formula to calculate the sum of cells A1 through A10?
=ADD(A1:A10)
=SUM(A1:A10)
=TOTAL(A1:A10)
=PLUS(A1:A10)
Which function finds the average of numbers in a range?
=SUM
=MEAN
=AVERAGE
=COUNT
What does the IF function do?
Adds all numbers in a range
Checks a condition and returns one of two results
Counts all cells in a range
Finds duplicate values
Which function counts cells that meet a specific condition?
=COUNT
=COUNTA
=COUNTIF
=COUNTBLANK
What is the main purpose of VLOOKUP?
To look up data vertically in a table
To verify data accuracy
To calculate totals by category
To create charts automatically
What is a Pivot Table used for?
Calculating averages
Summarizing and analyzing large data sets
Formatting text cells
Sorting names alphabetically
A Chart helps businesses by:
Encrypting data
Displaying data visually for better understanding
Backing up spreadsheets
Removing duplicates
In Excel, which symbol begins every formula?
@
+
=
#
