QUIZ (PART I) - BSCE 1G (1)

What file formats can be imported into Excel?

• .txt

• .csv

• .docx

• Both a and b

What shortcut is used to find data in a workbook?

• CTRL + H

• CTRL + F

• ALT + F4

• CTRL + Z

Which tab allows you to insert hyperlinks in Excel?

• Page Layout

• Insert

• Data

• View

Where can you adjust row height and column width?

• View tab

• Page Layout tab

• Home tab

• File tab

The Quick Access Toolbar can be customized through:

• File > Options

• Home > Editing

• Insert > Links

• View > Freeze Panes

How do you freeze the top row of a worksheet?

• View > Freeze Panes > Freeze Top Row

• Insert > Freeze

• Data > Freeze

• Page Layout > Freeze Top Row

Which option allows modifying headers and footers?

• Insert > Links

• View > Page Break Preview

• Data > Outline

• Page Layout > Page Setup

Which tab contains workbook view options?

• Home

• Data

• View

• Review

Where can you inspect a workbook for issues?

• File > Print

• File > Info > Check for Issues

• View > Workbook Views

• Page Layout > Print Area

What shortcut allows saving a workbook in an alternative format?

• F12

• CTRL + S

• ALT + F4

• SHIFT + F3