Excel Lessons 1-3

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

What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?

• Quick Access Toolbar

• Hot Keys

• Mini Toolbar

• Key Tips

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

• Entry

• Workbook

• Row

• Column

What occurs when the cursor is moved over a cell and a user clicks?

• The row is selected.

• The cell is selected.

• The column is selected.

• The worksheet is selected.

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?

• Freeze Panes

• Split

• Hide

• Unhide

Which view is the default view used in Microsoft Excel?

• Page Layout

• Print

• Normal

• Web

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

• Form

• Boilerplate

• Smart Sheet

• Template

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

• Exit

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

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