FBA-Lab2-Working with Worksheet MCQs

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

To increase workbook size

To lock the worksheets

To indicate that the worksheets contain related information

To make formulas work faster

Correct! Wrong!

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

Merge Cells

Freeze Panes

AutoFit Column Width

Wrap Text

Correct! Wrong!

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

Excel creates a new blank worksheet

Excel opens a new workbook

Excel deletes the current worksheet

Excel renames the current sheet

Correct! Wrong!

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

Hide

Protect

Rename

Delete

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

Data → Sort → Hide

View → Hide → Column

Correct! Wrong!

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

Duplicate workbook

Create a copy

Move selected sheet

Copy formatting only

Correct! Wrong!

Which statement about deleting a worksheet is correct?

Excel deletes only the formatting of the worksheet

Undo cannot reverse worksheet deletion

The worksheet can always be restored using Undo

Excel automatically saves a backup copy of the worksheet

Correct! Wrong!

Which shortcut key inserts a new worksheet in Excel?

Shift + F11

Alt + F11

Ctrl + Shift + W

Ctrl + N

Correct! Wrong!

Where are worksheet tabs located in Excel?

At the bottom of the Excel window

At the top of the Ribbon

On the left side of the worksheet

Inside the Formula Bar

Correct! Wrong!

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

Paintbrush icon

Hand pointer

Cross sign

A vertical line with arrows on both sides

Correct! Wrong!

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

Row 11

Row 10

Any row

Row 9

Correct! Wrong!

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

Alt + Tab

Shift + Tab

Ctrl + Page Up / Page Down

Ctrl + Arrow Keys

Correct! Wrong!

FBA-Lab2-Working with Worksheet MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements

FBA-Lab2-Working with Worksheet MCQs

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

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

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

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

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

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

Which statement about deleting a worksheet is correct?

Which shortcut key inserts a new worksheet in Excel?

Where are worksheet tabs located in Excel?

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

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

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

Submit a Comment Cancel reply