Mcqs: computer mcqs online test

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

 Correct Answer: a

81. A worksheet range is a

a. A command used for data modeling

b. A range of values such as from 23 to 234

c. A group of cells

d. A group of worksheets

 Correct Answer: c

82. The auto calculate feature

a. Can only add values in a range of cells

b. Provides a quick way to view the result of an arithmetic operation on a range of

cells

c. Automatically creates formulas and adds them to a worksheet

d. A and c

 Correct Answer: b

83. Excel uniquely identifies cells within a worksheet with a cell name

a. Cell names

b. Column numbers and row letters

c. Column letters and row numbers

d. Cell locator coordinates

 Correct Answer: c

84. To drag a selected range of data to another worksheet in the same workbook, use the

a. Tab key

b. Alt key

c. Shift key

d. Ctrl key

Correct Answer: D

85. Hyperlinks can be

a. Text

b. Drawing objects

c. Pictures

d. All of above

Correct Answer: d

86. To activate the previous cell in a pre-selected range, press

a. The Alt key

b. The Tab key

c. The Enter key

d. None of the above

Correct Answer: d

87. Which button do yu click to add up a series of numbers? 

a. The autosum button

b. The Formula button

c. The quicktotal button

d. The total button

Correct Answer: a

88. When the formula bar is active, you can see

a. The edit formula button

b. The cancel button

c. The enter button

d. All of the above

Correct Answer: d

89. In a worksheet you can select

a. The entire worksheet

b. Rows

c. Columns

d. All of the above

Correct Answer: b

Made easy test series