Excel Lesson 1

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?

• Print Selection
• Print Active Sheet
• Print Entire Workbook

John’s workbook includes 3 worksheets.  Which option should he choose to print them?

• Print Selection
• Print Active Sheet
• Print Entire Workbook

Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?

• Close
• Save
• Save as

To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?

• File details
• Document Properties

What area contains the command used to print a worksheet in Microsoft Excel?

• Home Ribbon
• Page Layout Ribbon
• File Tab

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?

• Form
• SmartSheet
• Template

John has highlighted the data he would like to print.  Which print option should he choose?

• Print Selection
• Print Active Sheets
• Print Entire Workbook

How is a cell reference in a formula and its corresponding location in a worksheet identified?

• Cell reference and cell location are circled
• Cell reference and cell location are outlined in matching colors

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?

• Workbook views
• Show
• Zoom
• Window

What command will arrange Microsoft Excel windows so that they appear side by side on the screen?

• Zoom to Selection
• New Window
• Arrange All
• Freeze Panes