Microsoft Excel Questions

MCQ bookmark_border

41.

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

A

Edit > Clear > Contents

B

Edit > Clear > All

C

Edit > Delete

D

All of above

Correct Answer: A

The Delete key of keyboard is assigned to Clear Contents command in Excel. Clear Contents will clear only the data, will not clear any formats.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

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

A

From Edit menu choose Clear and then Formats

B

From Edit menu choose Delete

C

Click on Remove Formatting tool on Standard Toolbar

D

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

Correct Answer: A

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

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

A

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

B

Click on Sheet 3 and from Edit menu choose Delete

C

Both of above

D

None of above

Correct Answer: A

Right-click the tab and choose Delete from its shortcut menu in All version of excel.
In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS
Microsoft Excel 2007 and earlier Press

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

Which of the following action removes a sheet from workbook?

A

Select the sheet, then choose Edit > Delete Sheet

B

Select the sheet then choose Format > Sheet > Hide

C

Both of above

D

None of above

Correct Answer: A

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.
In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

Which of the following action removes a sheet from workbook?

A

Select the sheet, then choose Edit > Delete Sheet

B

Select the sheet then choose Format > Sheet > Hide

C

Both of above

D

None of above

Correct Answer: A

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.
In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

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

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

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

Correct Answer: C

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

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

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

A

Ctrl + R

B

Ctrl + Shift + R

C

Ctrl + H

D

Ctrl + F

Correct Answer: C

Ctrl + H shortcut key is usedto replace a data with another in sheet.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

Comments can be added to cells using ________

A

Home > Comments

B

Insert > Comment

C

Data > Comments

D

Review > Comments

Correct Answer: D

Comments can be added to cells using Review > Comment.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

Comments can be added to cells using ________

A

Home > Comments

B

Insert > Comment

C

Data > Comments

D

Review > Comments

Correct Answer: D

Comments can be added to cells using Review > Comment.

Check Answer report_problem Report forum Discussion