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
_____________________________________________________________________
Leave a Reply