Microsoft Excel Quiz Questions and Answers - MS Excel MCQ - Page 2

(Showing: 11 - 20 out of 125 MCQs)

Microsoft Excel Quiz Questions and Answers from MS Office topic. These MS Excel mcq are important for the banking examinations. Important MS Office Computer Awareness Questions Answers (mcq) listing for techincal aptitude for IBPS PO , MT Exam, Bank PO, Clerk, SBI, RBI and other competitive.

11. A worksheet can have a maximum of .... Number of rows
[A] 256
[B] 1024
[C] 32000
[D] 65535
Loading...
12. How many characters can be typed in a single cell in Excel?
[A] 256
[B] 1024
[C] 32000
[D] 65535
Loading...
13. A typical worksheet has ..... Number of columns
[A] 128
[B] 256
[C] 512
[D] 1024
Loading...
14. 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
Loading...
15. Which of the following formulas is not entered correctly? a. b. c. d.
[A] =10+50
[B] =B7*B1
[C] =B7+14
[D] 10+50
Loading...
16. Which symbol must all formula begin with?
[A] =
[B] +
[C] (
[D] @
Loading...
17. What symbol is used before a number to make it a label?
[A] ” ( quote )
[B] = ( equal )
[C] _ ( underscore )
[D] ‘ ( apostrophe )
Loading...
18. Which menu option can be sued to split windows into two
[A] Format > window
[B] View > window > split
[C] Window > split
[D] View > split
Loading...
19. Which of the following is an absolute cell reference?
[A] !A!1
[B] $A$1
[C] #a#1
[D] A1
Loading...
20. The autofill feature
[A] extends a sequential series of data
[B] automatically adds range of cell values
[C] applies a boarder around the selected cells
[D] All of the above
Loading...
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)