WorksheetsExcel
Total questions: 21
Worksheet time: 21mins
What is the default file extension of an Excel workbook?
.docx
.xlsx
.xlsm
.pptx
Which of the following is used to start a formula in Excel?
#
=
@
$
What does the SUM function do in Excel?
Sorts numbers
Adds numbers
Subtracts numbers
Multiplies numbers
Which of the following is NOT a valid Excel function?
AVERAGE
COUNT
MAXIMUM
IF
What is a cell in Excel?
A graph
A file
The intersection of a row and column
A worksheet
How do you refer to cell A1 in a formula?
A1
(A1)
[A1]
{A1}
Which shortcut key is used to save an Excel file?
Ctrl + P
Ctrl + X
Ctrl + S
Ctrl + Z
What is the maximum number of rows in an Excel 2016 worksheet?
65536
1048576
50000
32768
Excel can only handle text data.
True
False
You can use charts in Excel to visualize data.
✅ True
❌ False
The IF function is used to sort data.
❌ False
✅ True
Excel is a spreadsheet program.
❌ False
✅ True
Which formula correctly calculates the total of cells A1 to A5?
=TOTAL(A1:A5)
=ADD(A1:A5)
=SUM(A1:A5)
=A1+A5
What formula would you use to calculate a 10% discount on the value in B2?
=B2 + 10%
=B2 * 10
=B2 * 10%
=10% - B2
Which function returns the highest value in a range?
MAXIMUM()
HIGHEST()
MAX()
TOP()
What does the COUNTBLANK function do?
Counts all blank rows
Counts all blank cells in a range
Counts all cells with text
Counts all formulas
Which formula calculates the average of numbers in cells A1 to A10?
=MEAN(A1:A10)
=AVG(A1:A10)
=AVERAGE(A1:A10)
=COUNT(A1:A10)
Which formula returns the value from the first row in the same column where a match is found?
VLOOKUP
HLOOKUP
INDEX
IF
What is the result of the formula =IF(B1>100, "Bonus", "No Bonus") when B1 is 150?
Bonus
No Bonus
Error
0
Which function counts only the numeric values in a range?
a) COUNTBLANK
b) COUNT
c) COUNTA
d) COUNTNUM
Draw a smiley
