WorksheetsCOMPUTER5: Written Work 4.1
Total questions: 10
Worksheet time: 3hrs 30mins
What letter is displayed in MS Excel logo?
W
X
P
A
Where can you find the name of the cell?
Name box
Formula bar
Column
Row
Which of the following is not a type of data in MS Excel?
Formula
Cell range
Text Values
Numbers
Which of the following is an example of cell range?
A3
A3:J7
AB123
=A1+B2
Which of the following is not a numerical data?
HELLO123
123
0.123
12.30
Which of the following is the intersection of rows and columns in MS Excel?
cell
data
name box
formula
Given the grid, which of the following formulas will NOT give the result 10?
=A1+A2
=B1*A1
=B1+C2
=(A1*B1)/B2
Base on the given grid, what will be the result when you use the formula =(D1*C1)+(A2*C2)?
59
49
39
29
Which of the following is NOT a valid Excel formula?
=B8+C8
=B8 x C8
=B8 / C8
=B8 - C8
What is the correct order of precedence when computing in MS Excel?
PDSAM
SPAMD
PMDAS
PMSAD
