Multiple Choice Question for Microsoft Excel || 9
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
81 Which of the
following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
82 What symbol is used before a number to make
it a label?
A. ? (quote)
B. = (equal)
C. _ (underscore)
D. ?
(apostrophe)
83 Which symbol must all formula
begin with?
A. =
B. +
C. (
D. @
84 Which
of the following formulas is not entered correctly?
A. =10+50
B. =B7*B1
C.
=B7+14
D. 10+50
85 Which of the following
formulas will Excel Not be able to calculate?
A. =SUM(Sales)-A3
B. =SUM
(A1:A5)*.5
C. =SUM(A1:A5)/(10-10)
D. =SUM(A1:A5)-10
86 A typical worksheet has ?. Number of columns
A. 128
B. 256
C. 512
D. 1024
87 How many characters can be
typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
88 A worksheet can have a maximum of ?. Number of
rows
A. 256
B. 1024
C. 32000
D. 65535
89
Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 57
D. Serial Number 50771
90 The chart
wizard term data series refers to
A. A chart legend
B. A collection of chart
data markers
C. A set of values you plot in a chart
D. A data label