MS Excel MCQs

Question 1

Which of the following you can paste selectively using Paste Special command?

Accepted Answer

All of above

Answer

Validation

Answer

Formats

Answer

Formulas

Question 2

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Accepted Answer

Divide

Answer

Square

Answer

Percentage

Answer

Goal Seek

Question 3

Edit > Delete command

Accepted Answer

Deletes selected cells

Answer

Deletes the content of a cell

Answer

Deletes Formats of cell

Answer

Deletes the comment of cell

Question 4

To remove the content of selected cells you must issue ______ command

Accepted Answer

Clear Contents

Answer

Delete

Answer

Clear All

Answer

Clear Delete

Question 5

The Delete key of keyboard is assigned to which command in Excel?

Accepted Answer

Edit > Clear > Contents

Answer

Edit > Clear > All

Answer

Edit > Delete

Answer

All of above

Question 6

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Accepted Answer

From Edit menu choose Clear and then Formats

Answer

From Edit menu choose Delete

Answer

Click on Remove Formatting tool on Standard Toolbar

Answer

Double click the Format Painter and then press Esc key in keyboard

Question 7

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

Accepted Answer

Right click on Sheet Tab of third sheet and choose Delete from the context menu

Answer

Click on Sheet 3 and from Edit menu choose Delete

Answer

Both of above

Answer

None of above

Question 8

Which of the following action removes a sheet from workbook?

Accepted Answer

Select the sheet, then choose Edit > Delete Sheet

Answer

Select the sheet then choose Format > Sheet > Hide

Answer

Both of above

Answer

None of above

Question 9

While Finding and Replacing some data in Excel, which of the following statement is valid?

Accepted Answer

You can Find and Replace within the sheet or workbook

Answer

Excel does not have option to match case for find

Answer

Both are valid

Answer

None are valid