Lesson 01 Unit 1 Excel 2019/365 MOAC

    When you are in the Excel application, what shortcut key can you use to open an existing workbook?

• Ctrl+Alt+O
• Ctrl+O
• Shift+O
•     Ctrl+Shift+O

    Which area of the Excel application has the following three commands: Save, Undo, and Redo?

•     Status Toolbar
•     Mini Toolbar
• Quick Access Toolbar
•     Formula Bar

    How can you access Backstage view?

•     Windows key
• Select File Tab
• Select Home Tab
•     Ctrl+B

    To create a new workbook: (Select ALL correct answers)

•     Go to File > New
• Select Ctrl+N on your keyboard
•     Select Ctrl+O on your keyboard
•     Go to File > Open

    Where will you find the formula bar?

•     File > Open
•     File > Options
•     Directly below the ribbon (correct answer)
•     On the Quick Access Toolbar

    If you double-click a ribbon tab twice, what happens to the ribbon?

•     It disappears
• It will show tabs only
•     It will auto hide
•     It will move to the bottom of the screen

    If you have the ribbon on the Auto-hide setting, there will be an ____________ next to the Ribbon Display Options.

• …
• __
• •
• ‡

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

• Print Layout

• Page Layout

• ScreenTips

• Split Windows

Which of the following indicates a proper cell address?

• 3A

• :A3

• A3

• @A3

Which of the following describes a column?

• Identified by letters; runs vertically

• Identified by letters; runs horizontally

• Identified by numbers; runs vertically

• Identified by numbers; runs horizontally