MS Excel MCQs

Question 1

Which of the following is not true about Find and Replace in Excel

Accepted Answer

You can search for bold and replace with italics

Answer

You can decide whether to look for the whole word or not

Answer

You can search in formula too

Answer

You can search by rows or columns or sheets

Question 2

You can move a sheet from one workbook into new book by

Accepted Answer

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Answer

From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

Answer

From Edit menu choose Move of Copy then choose (Move to end) and click OK

Answer

None of above

Question 3

What is the shortcut key to replace a data with another in sheet?

Accepted Answer

Ctrl + H

Answer

Ctrl + R

Answer

Ctrl + Shift + R

Answer

Ctrl + F

Question 4

Comments can be added to cells using ________

Accepted Answer

Review > Comments

Answer

Home > Comments

Answer

Insert > Comment

Answer

Data > Comments

Question 5

Which menu option can be used to split windows into two?

Accepted Answer

View > Window > Split

Answer

Review > Window

Answer

Window > Split

Answer

View > Split

Question 6

Getting data from a cell located in a different sheet is called ________

Accepted Answer

Referencing

Answer

Accessing

Answer

Updating

Answer

Functioning

Question 7

Which of the following is not a valid data type in Excel?

Accepted Answer

Character

Answer

Number

Answer

Label

Answer

Date/Time

Question 8

Which elements of a worksheet can be protected from accidental modification?

Accepted Answer

All of the above

Answer

Contents

Answer

Objects

Answer

Scenarios

Question 9

A numeric value can be treated as label value if ________ precedes it.

Accepted Answer

Apostrophe ( ‘ )

Answer

Exclamation ( ! )

Answer

Hash ( # )

Answer

Tilde ( ~ )