NEW
Font size
WorksheetsExcel Basics & Essential Functions Quiz (week 1)
Total questions: 15
Worksheet time: 8mins
Which key combination is used to copy in Excel?
Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + A
Which function adds numbers together?
SUM
ADD
TOTAL
COMBINE
Which function counts the number of numeric entries in a range?
COUNTA
COUNT
MIN
MAX
Which function counts both text and numbers?
COUNT
COUNTA
COUNTIF
SUM
The function that gives the smallest value in a dataset is:
SMALL
MIN
LOWEST
BOTTOM
The function that gives the largest value in a dataset is:
MAX
TOP
HIGH
LARGE
Which formula calculates the average of A1:A10?
=SUM(A1:A10)/10
=AVG(A1:A10)
=AVERAGE(A1:A10)
=MEAN(A1:A10)
In the formula `=IF(B2>=50,"Pass","Fail")`, if B2 = 40, the result is:
Pass
Fail
Error
Blank
Which function rounds a number up or down?
ROUND
APPROX
LIMIT
FIX
What is the difference between relative and absolute referencing?
Relative references stay fixed, absolute changes
Relative changes when copied, absolute stays fixed
Both stay fixed
Both change when copied
Which shortcut inserts a new worksheet?
Shift + F11
Ctrl + N
Ctrl + T
F2
Which function checks if a condition is true or false?
CHECK
IF
TRUE
VERIFY
What does COUNTA exclude?
Numbers
Text
Blanks
Dates
The symbol `$` in cell references is used for:
Currency formatting
Absolute reference
Error checking
Shortcut
To sort data A–Z, you use:
Data → Sort → Z–A
Data → Sort → A–Z
Insert → Sort
Review → Sort
