Excel 1.1 & 1.2 Key Terms

Question 0

Autofitting

Answer 0

Eliminates any empty space by matching the row height or column width to its tallest or longest entry.

Question 1

Formula View

Answer 1

A view of the workbook contents that displays formulas instead of the resulting values.

Question 2

Range Referance

Answer 2

Indicates the location and size of a cell range.

Question 3

Arithmetic Operators

Answer 3

Used to perform addition, subtraction, multiplication, division, and exponentiation. For example, =B1+B2

Question 4

Order of Procedure

Answer 4

Predefined rules to determine the sequence in which operators are applied in a calculation.

Question 5

Spreadsheet

Answer 5

A collection of text and numbers laid out in a rectangular grid.

Question 6

Chart Sheet

Answer 6

Contains an Excel chart that provides a visual representation of worksheet data.

Question 7

Text Data

Answer 7

Any combination of letters, numbers, and symbols that form words and sentences.

Question 8

Number Data

Answer 8

Any numerical value that can be used in a mathematical calculation.

Question 9

AutoComplete

Answer 9

As you type text into an active cell, Excel tries to anticipate the remaining characters by displaying text that begins with the same letters as a previous entry in the same column.