FBA-Lab2-Working with Worksheet MCQs

(Tab to RIGHT OPTION to see the answer.)

What happens when you click the + icon beside the worksheet tabs?

Excel creates a new blank worksheet

Excel renames the current sheet

Excel opens a new workbook

Excel deletes the current worksheet

Correct! Wrong!

Which shortcut key inserts a new worksheet in Excel?

Alt + F11

Ctrl + Shift + W

Ctrl + N

Shift + F11

Correct! Wrong!

Which of the following is the correct sequence for hiding a column from the Ribbon?

Insert → Column → Hide

Data → Sort → Hide

View → Hide → Column

Home → Format → Hide & Unhide → Hide Columns

Correct! Wrong!

Which Excel command is used to remove a hidden row or column from view temporarily?

Rename

Hide

Protect

Delete

Correct! Wrong!

If you want a new row to appear above Row 10, which row should you select before choosing Insert?

Any row

Row 10

Row 11

Row 9

Correct! Wrong!

Which Excel feature allows you to make a column wide enough to show all its contents automatically?

Merge Cells

Wrap Text

AutoFit Column Width

Freeze Panes

Correct! Wrong!

Which mouse pointer shape appears when you place the cursor between two column letters to resize a column?

Hand pointer

Paintbrush icon

Cross sign

A vertical line with arrows on both sides

Correct! Wrong!

Which shortcut key is used to move between worksheets in a workbook?

Ctrl + Page Up / Page Down

Alt + Tab

Shift + Tab

Ctrl + Arrow Keys

Correct! Wrong!

Where are worksheet tabs located in Excel?

At the top of the Ribbon

At the bottom of the Excel window

Inside the Formula Bar

On the left side of the worksheet

Correct! Wrong!

What is the main purpose of assigning the same color to multiple worksheet tabs?

To make formulas work faster

To increase workbook size

To indicate that the worksheets contain related information

To lock the worksheets

Correct! Wrong!

Which option should be selected in the Move or Copy dialog box to duplicate a worksheet?

Copy formatting only

Move selected sheet

Create a copy

Duplicate workbook

Correct! Wrong!

Which statement about deleting a worksheet is correct?

Excel automatically saves a backup copy of the worksheet

Undo cannot reverse worksheet deletion

Excel deletes only the formatting of the worksheet

The worksheet can always be restored using Undo

Correct! Wrong!

FBA-Lab2-Working with Worksheet MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements