Excel Lessons 1-3 Test Review

A cell that is highlighted or outlined by a bold black rectangle and is the currently selected cell.

• column

• row

• active cell

• name box

A box on the grid identified by the intersection of a column and a row.

• cell

• active cell

• name box

• worksheet

Cells that run from top to bottom in a worksheet and are identified by letters.

• columns

• rows

• name box

• active cell

Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses enter, t he insertion point moves to that cell

• worksheet

• formula bar

• name box

• active cell

A toolbar that gives you fast and easy assess to the tools you use most often in Excel.

• formula bar

• name box

• workbook

• quick access toolbar

A collection of worksheets in a single file.

• workbook

• formula

• cell

• quick access toolbar

A page in a workbook that consists of a grid or rows and columns in which you can enter text, values, and formulas and perform calculations

• workbook

• worksheet

• function

• cell

An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

• a dialog box or task pane

• an additional workbook

• a list of worksheets

• an additional part of the current range

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

• page layout

• print layout

• synchronous scrolling

• screen tips

When you split a window, the window is divided into how many panes?

• 2

• 3

• 4

• 2 or 4