Excel Lesson 1

Front 1

Active Cell

Back 1

the cell in the worksheet in which you can type data

Front 2

Name Box

Back 2

cell reference area located below the ribbon, displays the cell reference of the active cell

Front 3

Formula Bar

Back 3

appears to the right of the name box and displays a formula when the cell of a worksheet contains a calculated value

Front 4

Formula

Back 4

an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and cell A2

Front 5

Range

Back 5

a group of selected cells

Front 6

Adjacent Range

Back 6

all cells touch each other and form a rectangle

Front 7

Range Reference

Back 7

which lists both the cell in the upper-left corner and the cell in the lower-right corner, seperated by a colon

Front 8

Nonadjacent Range

Back 8

includes two or more adjacent ranges and selected cells

Front 9

Portrait Orientation

Back 9

for a page turned so that its shorter side is at the top

Front 10

Landscape Orientation

Back 10

for a page turned so that its longer side is at the top

Front 11

Cell Reference

Back 11

each cell is identified / formed by combining the cell's column letter and row number

Front 12

Cell

Back 12

is the intersection of a row and a column

Front 13

Cell Reference

Back 13

Identifies each cell

Front 14

Active Worksheet

Back 14

The worksheet that is displayed in the work area is called the active worksheet

Front 15

Range Reference

Back 15

Identifies the range

Front 16

Row

Back 16

Rows appear horizontally and are identified by numbers on the left side of the worksheet window

Front 17

Workbook

Back 17

The file used to store worksheets

Front 18

Sheet Tab

Back 18

Where the name of each worksheet appears, at the bottom of the worksheet window

Front 19

Spreadsheet

Back 19

Is a grid of rows and columns in which you enter text, numbers, and the results of calculations

Front 20

Range Reference

Back 20

Identifies the range