Mcqs: computer mcqs online test

 70. You can set Page Border in Excel from

 A) From Border tab in Format Cells dialog box

 B) From Border tool in Formatting toolbar

 C) From Line Style tool in Drawing toolbar

 D) You can not set page border in Excel

 Correct Answer: D

71. You can check the conditions against __________ when applying conditional

formatting

 A) Cell value

 B) Formula 

 C) Both of above

 D) None of above

 Correct Answer: C

72. When a range is selected, how can you activate the previous cell?

A) Press the Alt key

 B) Press Tab

 C) Press Enter

 D) None of above

 Correct Answer: D

73. Each excel file is a workbook that contains different sheets. Which of the following

can not be a sheet in workbook?

 A) work sheet

 B) chart sheet

 C) module sheet

 D) data sheet

 Correct Answer: D

74. Which of the following Excel screen components can NOT be turned on or off?

 A) Formula Bar

 B) Status Bar

 C) Tool Bar

 D) None of above

 Correct Answer: D

75. Which of the following option is not available in Paste Special dialog box?

 A) Add

 B) Subtract

 C) Divide

 D) SQRT

 Correct Answer: D

76. Which of the cell pointer indicates that you can fill series?

 A) Doctor’s symbol (Big Plus)

 B) small thin plus icon

 C) Mouse Pointer with anchor at the tip

 D) None of above

 Correct Answer: C

77. Which of the following is an absolute cell reference?

 a. !A!1

 b. $A$1

 c. #a#1

 d. A1

 Correct Answer: b

78. Which symbol must all formula begin with?

a. =

b. +

c. (

d. @

 Correct Answer: a

79. Which of the following formulas is not entered correctly?

a. =10+50

b. =B7*B1

c. =B7+14 

d. 10+50

 Correct Answer: d

Made easy test series