FBA-Lab2-Working with Worksheet MCQs

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

Create a copy

Move selected sheet

Duplicate workbook

Copy formatting only

Correct! Wrong!

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

Row 9

Row 10

Any row

Row 11

Correct! Wrong!

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

Home → Format → Hide & Unhide → Hide Columns

Insert → Column → Hide

View → Hide → Column

Data → Sort → Hide

Correct! Wrong!

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

Ctrl + Arrow Keys

Alt + Tab

Shift + Tab

Ctrl + Page Up / Page Down

Correct! Wrong!

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

Protect

Hide

Rename

Delete

Correct! Wrong!

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

To lock the worksheets

To indicate that the worksheets contain related information

To make formulas work faster

To increase workbook size

Correct! Wrong!

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

Excel renames the current sheet

Excel opens a new workbook

Excel creates a new blank worksheet

Excel deletes the current worksheet

Correct! Wrong!

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

Cross sign

Hand pointer

A vertical line with arrows on both sides

Paintbrush icon

Correct! Wrong!

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

Wrap Text

Freeze Panes

AutoFit Column Width

Merge Cells

Correct! Wrong!

Which shortcut key inserts a new worksheet in Excel?

Ctrl + N

Shift + F11

Alt + F11

Ctrl + Shift + W

Correct! Wrong!

Which statement about deleting a worksheet is correct?

The worksheet can always be restored using Undo

Excel automatically saves a backup copy of the worksheet

Excel deletes only the formatting of the worksheet

Undo cannot reverse worksheet deletion

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!

FBA-Lab2-Working with Worksheet MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements

FBA-Lab2-Working with Worksheet MCQs

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

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

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

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

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

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

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

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

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

Which shortcut key inserts a new worksheet in Excel?

Which statement about deleting a worksheet is correct?

Where are worksheet tabs located in Excel?

Submit a Comment Cancel reply