FBA-Lab1-MS Excel Fundamentals MCQs

(Tab to RIGHT OPTION to see the answer)

Which command is commonly available on the Quick Access Toolbar?

Replace

Undo

Zoom Slider

Formula Bar

Correct! Wrong!

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

Name Box

Formula Bar

Vertical Scroll Bar

Sheet Tabs

Correct! Wrong!

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

The File tab

The Print dialog box

A chart window

A new workbook with an empty worksheet

Correct! Wrong!

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

Scroll Bars

Tabs

Groups

Worksheets

Correct! Wrong!

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

Export

Browse

Correct! Wrong!

How are columns identified in an Excel worksheet?

By symbols

By numbers such as 1, 2, 3

By colors

By letters such as A, B, C

Correct! Wrong!

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

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

To print the workbook

To close the workbook

To delete the workbook

Correct! Wrong!

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

Name Box

Quick Access Toolbar

Zoom Slider

Status Bar

Correct! Wrong!

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

To browse the internet

To play videos

To change Windows settings

To type and organize data in rows and columns

Correct! Wrong!

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

The worksheet is named D7

The file has been saved 7 times

The selected cell is in column D and row 7

The workbook contains 7 worksheets

Correct! Wrong!

FBA-Lab1-MS Excel Fundamentals MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Needs Improvement