Ms Excel Online Solved MCQS

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. 0.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