FBA-Lab1-MS Excel Fundamentals MCQs

(Tab to RIGHT OPTION to see the answer)

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

To play videos

To change Windows settings

To browse the internet

To type and organize data in rows and columns

Correct! Wrong!

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

Browse

Export

Correct! Wrong!

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

The File tab

A chart window

The Print dialog box

A new workbook with an empty worksheet

Correct! Wrong!

Which command is commonly available on the Quick Access Toolbar?

Undo

Replace

Formula Bar

Zoom Slider

Correct! Wrong!

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

To close the workbook

To print the workbook

To delete the workbook

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

Correct! Wrong!

How are columns identified in an Excel worksheet?

By letters such as A, B, C

By colors

By numbers such as 1, 2, 3

By symbols

Correct! Wrong!

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

Groups

Scroll Bars

Worksheets

Tabs

Correct! Wrong!

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

Vertical Scroll Bar

Name Box

Sheet Tabs

Formula Bar

Correct! Wrong!

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

Status Bar

Name Box

Quick Access Toolbar

Zoom Slider

Correct! Wrong!

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

The file has been saved 7 times

The selected cell is in column D and row 7

The workbook contains 7 worksheets

The worksheet is named D7

Correct! Wrong!

FBA-Lab1-MS Excel Fundamentals MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Needs Improvement