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

(Showing: 71 - 80 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.

71. A numeric value can be treated as label value if ...... precedes it.
[A] Apostrophe ( ‘ )
[B] Exclamation ( ! )
[C] Hash ( # )
[D] Tilde ( ~ )
72. Concatenation of text can be done using
[A] Apostrophe ( ‘ )
[B] Exclamation ( ! )
[C] Hash ( # )
[D] Ampersand ( & )
73. Getting data from a cell located in a different sheet is called ......
[A] Accessing
[B] Referencing
[C] Updating
[D] Functioning
74. Which of the following is not a valid data type in Excel?
[A] Number
[B] Character
[C] Label
[D] Date/Time
75. Which elements of a worksheet can be protected from accidental modification?
[A] Contents
[B] Objects
[C] Scenarios
[D] All of the above
76. What is the short cut key to replace a data with another in sheet?
[A] Ctrl + R
[B] Ctrl + Shift + R
[C] Ctrl + H
[D] Ctrl + F
77. Comments can be added to cells using ......
[A] Edit -> Comments
[B] Insert -> Comment
[C] File -> Comments
[D] View –> Comments
78. Which menu option can be used to split windows into two?
[A] Format -> Window
[B] View -> Window-> Split
[C] Window -> Split
[D] View –> Split
79. Which of the following is not true about Find and Replace in Excel
[A] You can search for bold and replace with italics
[B] You can decide whether to look for the whole word or not
[C] You can search in formula too
[D] You can search by rows or columns or sheets
80. You can move a sheet from one workbook into new book by
[A] From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
[B] From Edit menu choose Move of Copy then choose (Move to end) and click OK
[C] From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
[D] None of above
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)