FBA-Lab1-MS Excel Fundamentals MCQs

(Tab to RIGHT OPTION to see the answer)

How are columns identified in an Excel worksheet?

By colors

By numbers such as 1, 2, 3

By symbols

By letters such as A, B, C

Correct! Wrong!

What appears after you select “Blank Workbook” in Microsoft Excel?

The File tab

A chart window

A new workbook with an empty worksheet

The Print dialog box

Correct! Wrong!

Which feature in the bottom-right corner of Excel is used to zoom in or out of a worksheet?

Zoom Slider

Status Bar

Quick Access Toolbar

Name Box

Correct! Wrong!

Which option in Backstage View allows you to choose a location such as Desktop to save your workbook?

Browse

Export

Correct! Wrong!

The Font and Alignment sections found on the Home tab are examples of?

Groups

Worksheets

Tabs

Scroll Bars

Correct! Wrong!

Which feature is used to move from one worksheet to another in the same workbook?

Formula Bar

Vertical Scroll Bar

Name Box

Sheet Tabs

Correct! Wrong!

Which command is commonly available on the Quick Access Toolbar?

Undo

Zoom Slider

Replace

Formula Bar

Correct! Wrong!

What is the main purpose of the worksheet area in Excel?

To type and organize data in rows and columns

To play videos

To change Windows settings

To browse the internet

Correct! Wrong!

If the Name Box displays D7, what does it mean?

The file has been saved 7 times

The worksheet is named D7

The selected cell is in column D and row 7

The workbook contains 7 worksheets

Correct! Wrong!

Why would a user choose “Save As” instead of “Save”?

To print the workbook

To close the workbook

To delete the workbook

To save the workbook with a new name or in a new location

Correct! Wrong!

FBA-Lab1-MS Excel Fundamentals MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Needs Improvement