NEW
Font size
WorksheetsMS EXCEL REVIEW
Total questions: 20
Worksheet time: 10mins
What is the cell reference located at column D and row 8?
D8
8D
Row8ColD
D_8
Which function adds up all numbers in a range of cells?
SUM
COUNT
ADD
TOTAL
If cell A1 contains 10 and B1 contains 20, what is the result of =A1+B1?
30
10
20
200
Which of the following refers to a single box where a row and column intersect?
Cell
Column
Row
Range
Which formula correctly finds the average of cells A1 to A5?
=AVERAGE(A1:A5)
=AVG(A1:A5)
=SUM(A1:A5)/A5
=AVERAGE(A5:A1)
What will the formula =IF(A1>50, "Pass", "Fail") return if A1 = 60?
Pass
Fail
60
TRUE
What is the column letter of the cell located before column D?
C
E
B
F
What is the main purpose of a formula in Excel?
To calculate data automatically
To store images
To change font styles
To sort text alphabetically
If you type =SUM(A1:A3)*2, which operation happens first?
SUM
Multiplication
Division
The first cell in a worksheet is located at:
A. A1
B. 1A
C. A0
D. 0A
Which of the following formulas gives the same result as =A1+A2+A3+A4?
=SUM(A1:A4)
=ADD(A1:A4)
=AVERAGE(A1:A4)
=COUNT(A1:A4)
Which symbol is always used before writing a formula in Excel?
=
+
/
:
In a nested IF, what does the second IF statement test?
Another condition when the first is FALSE
A mathematical error
A chart formula
The average value
What will =IF(A1>70, "Excellent", IF(A1>50, "Good", "Needs Improvement")) return if A1=65?
Good
Excellent
Needs Improvement
Invalid
Which operation is done first in the formula =5+10*2?
Multiplication
Addition
Division
Subtraction
A teacher wants to count how many students scored above 75. Which function should she use?
COUNTIF
SUM
AVERAGE
MAX
What is the range from cell B2 to D4 called?
B. D4:B2
C. Range B-D
D. 2B:4D
Which of these represents an incorrect formula?
=SUM(A1:B1:C1)
=SUM(A1:B1)
=AVERAGE(A1:A3)
=IF(A1>0,1,0)
What function would best determine the total grade percentage of a student?
=AVERAGE()
=SUM()
=COUNT()
=IF()
If B2=80 and the passing score is 75, what will =IF(B2>=75, "Passed", "Failed") display?
Passed
Failed
75
80
