Cis Chapter 1

Front 1

Active cell

Back 1

The selected cell in the worksheet; indicated with a dark border.

Front 2

Adjacent range

Back 2

A single rectangular block that include a group of contiguous cells.

Front 3

Argument

Back 3

Specifies the numbers, text, or cell references used by the function to calculate a value.

Front 4

Arithmetic operator

Back 4

Symbols, such as +, -, *, or /, used in a formula to perform a arithmetic calculations.

Front 5

AutoComplete

Back 5

Excel feature that anticipates the text you are about to enter by displaying text that begins with the same letter as a previous entry displays.

Front 6

AutoSum

Back 6

Toolbar button that automatically inserts the SUM function to calculate the sum of values in a range.

Front 7

Cell

Back 7

The intersection of a column and row in a worksheet.

Front 8

Cell reference

Back 8

The address of cell indicating its column and row location.

Front 9

Clear

Back 9

Erases the contents of a cell, leaving the cell in the worksheet.

Front 10

Column

Back 10

The horizontal portion of a worksheet identified by letters.

Front 11

Delete

Back 11

To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.

Front 12

Documentation sheet

Back 12

A worksheet that provides information about the content and purpose of the workbook.

Front 13

Edit mode

Back 13

Excel mode in which you can edit cell contents.

Front 14

Formula

Back 14

A mathematical expressions that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression describes the calculation to be done.

Front 15

Formula bar

Back 15

The bar located about the workbook window in which the contents of a cell in displayed.

Front 16

Formula view

Back 16

View in which cell formulas are displayed, rather than the values returned by the formulas.

Front 17

Function

Back 17

A predefined formula that performs calculations using specific values called arguments.

Front 18

Landscape orientation

Back 18

Orientation of a printed page in which the page is longer than it is tall.

Front 19

Name box

Back 19

Box located on the leftmost end of the Formula bar in which the cell reference to the active cell is also displayed.

Front 20

Nonadjacent range

Back 20

Cell range that is comprised of two or more separate adjacent ranges.

Front 21

Order of precedence

Back 21

A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second, and so forth.

Front 22

Range

Back 22

A group of worksheet cells, which can be adjacent or nonadjacent; also called a cell range.

Front 23

Range reference

Back 23

Identification of a cell range using the upper-left and lower-right corners of the rectangle selection of the cells.

Front 24

Row

Back 24

The vertical portion of a worksheet, identified by numbers.

Front 25

Sheet tab

Back 25

The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.

Front 26

Spell checker

Back 26

An Excel editing tool that you can use to check the words in the workbook against the program’s internal dictionary.

Front 27

Spreadsheet

Back 27

A tool used in business for budgeting, inventory management, and decision making for analyzing and reporting information.

Front 28

SUM function

Back 28

Math function that calculates the sum of a set of numbers.

Front 29

Tab scrolling buttons

Back 29

Navigation tools located in the lower-left corner of the Excel window used to view the worksheet tabs present in the workbook.

Front 30

Value

Back 30

Number entered in a cell that represents a quantity of some type, such as the number of units sold, stock prices, a exam score, and so on.

Front 31

What-if analysis

Back 31

An approach you can use in Excel to analyze workbook data by changing one or more of the values and then examining the recalculated values to determine the effect of the change.

Front 32

Workbook

Back 32

File in which Excel stores an electronic spreadsheet.

Front 33

Workbook window

Back 33

Window in which a workbook is displayed; also called worksheet window.

Front 34

Worksheet:

Back 34

Each workbook is made up of individual worksheets, or sheets containing formulas, functions, values, text, and graphics.

Front 35

Worksheet window

Back 35

Window in which a workbook is displayed; also called worksheet window.