Excel Lesson 2

Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?

• Exit
• Open
• Save
• Save as

David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?

• Autofill
• Filter
• Find and Replace
• Sort

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

• Paste
• Move
• Cut
• Copy

Alicia needs to move the data in cell B5 to cell E5. Which command would she select?

• Clear
• Copy
• Cut
• Format Painter

Which would be used to help organize and identify Microsoft Excel files by providing details about the files?

• File Details
• Document Properties
• File Facts
• Document Options

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
• Fit to one page

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

• Delete key
• Backspace Key
• Left arrow key
• Enter key

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?

• Label
• Value
• Formula
• Function

Which command on the Fill options dialog box is the default option if a month or day is entered?

• Copy Cells
• Fill Formatting Only
• Fill without Formatting
• Fill Series

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?

• Fill Handle
• Filler
• Copy Handle
• Copy Box