Excel Workbook Features and Functions

This video tutorial covers customizing the Quick Access Toolbar, exploring different Excel views, freezing rows and columns, splitting and arranging windows, adding workbook properties, and displaying formulas. It also provides instructions for an exercise lab to practice these skills.

What is the default location of the Quick Access Toolbar in Excel?

• Below the ribbon

• Above the ribbon

• On the left side of the screen

• On the right side of the screen

How can you add a button to the Quick Access Toolbar?

• By dragging it from the ribbon

• By right-clicking the button and selecting 'Add to Quick Access Toolbar'

• By double-clicking the button

• By clicking the 'Insert' tab

Which view in Excel shows the margins for printout?

• Normal view

• Page Break Preview

• Page Layout view

• Print Preview

What is the purpose of the Page Break Preview in Excel?

• To edit cell content

• To view and adjust page breaks before printing

• To add headers and footers

• To change the worksheet theme

How do you freeze the top two rows in an Excel worksheet?

• Select row 1 and click 'Freeze Panes'

• Select row 4 and click 'Freeze Panes'

• Select row 2 and click 'Freeze Panes'

• Select row 3 and click 'Freeze Panes'

What happens when you select cell B3 and click 'Freeze Panes'?

• Both the top two rows and the first column are frozen

• Nothing happens

• Only the first column is frozen

• Only the first row is frozen

What is the result of splitting a window in Excel?

• It divides the window into two scrollable areas

• It hides the ribbon

• It creates a new worksheet

• It duplicates the current worksheet

How can you arrange multiple windows of the same Excel file vertically?

• By clicking 'New Window' and then 'Tile'

• By clicking 'New Window' and then 'Arrange All' > 'Vertical'

• By clicking 'Split' and then 'Vertical'

• By clicking 'View Side by Side'

What is the purpose of adding properties to an Excel workbook?

• To change the workbook theme

• To categorize the workbook and make it searchable

• To add more worksheets

• To protect the workbook

How can you display all formulas in an Excel worksheet?

• By clicking 'Data' > 'Show Formulas'

• By clicking 'Formulas' > 'Show Formulas'

• By clicking 'View' > 'Show Formulas'

• By pressing Ctrl + F