3B Six Autos: Status Bar, ScreenTips, Views, Backstage, QAT, Navigation

What is the Status Bar in Excel?

At the bottom, shows Sum/Avg/Count when you highlight cells without doing math

What info can the Status Bar display when multiple cells are selected?

Sum, Average, Count, Min, Max.

What are ScreenTips in Excel?

Idk what something is, move mouse towards it and a name will pop up (ex. go near formula bar and it will say formula bar)

How can ScreenTips help you learn Excel shortcuts?

show keyboard shortcut for each tool

Where are the Zoom controls located?

bottom right in status bar

What does Normal View show?

standard spreadsheet layout

What does Page Layout View show?

Shows how the sheet will look when printed, including margins, headers, and footers.

When should you use Page Break Preview?

When adjusting where pages break before printing.

What is this? 

Normal view

What is this?

Page layout preview

What is this?

Page layout

What is Backstage View in Excel?

The screen that appears when you click File, containing options for saving, printing, sharing, info, and settings.

Which tab do you click to access printing, exporting, properties, and account settings?

File (Backstage View)

What is the Quick Access Toolbar (QAT)?

A customizable toolbar above the Ribbon for frequently used commands like Add save, undo, redo, or email to it

Why use the QAT?

To have one-click access to commands you use often, instead of switching tabs.

How do you add a command to the QAT?

Click the drop-down arrow on the QAT → select the command to add.

A student wants to quickly view where page breaks fall before printing. Which view should they use?

Page Break Preview.

You highlighted cells and see Sum, Average, and Count — but you never typed a formula. What feature did Excel use?

Status Bar calculation preview.