150 very important Excel MCQs for test and interview

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+114,

d. 10+50,

85. Which of the following, formulas will following, formulas 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. 547

d. 1021””””””’

87. How many characters, can be typed in a, single cell in Excel?

a. 256,

b. 1024,

c. 3200,0

d. 65535,

88. A “worksheet” can have a maximum, of Number of, rows:

a. 256,

b. 1024,

C. 32000,

d. 655355,

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,