Spreadsheet Study Sheet



Excel Spreadsheet Vocab Sheet

Task: Use the glossary to define the following terms. Use may need to locate the term inside of the chapter on Excel.

Vocabulary:

##### Cell is too small to fit the data

= Formula

Absolute Cell Reference Cell reference that does not adjust to the new cell location when copied or moved

Active Cell Highlighted cell ready for data

Auto sum The Greek Symbol, Sigma; to automatically add up cells

Cell intersection of a row and column in a spreadsheet

Cell Alignment Feature that automatically aligns the cells

Cell Reference Identifies the cell by row number and column letter

Charts: Graphical representation of data contained in a worksheet

Bar- Using colored bars to represent data

Line- Points plotted relevant to data and connected with lines

Pie- A circle is divided among percentage of data

Column Appear vertically in a spreadsheet and are identified by letters

F1 Brings up the help screen

F4 Delete

F5 Go to

Fill Copies data into cells adjacent to the original

Formula equation that calculates a new value from values currently on the worksheet

Formula Bar appears below the toolbar in the worksheet; displays a formula when the cell contains a value

Functions used to insert dates and certain kinds of text into a worksheet

Name Box area on the left side of the formula bar that identifies the reference of the active cell

Operands numbers or cell references used in calculations in the formulas of worksheets

Operators tells Excel what to do with operands in a formula

Order of Evaluation sequence of calculation in a worksheet formula

Protection prevents accidental changed from being made in a worksheet

Range selected group of cells in a worksheet identified by the cell in the upper-left corner.

Relative Cell Reference cell reference that adjusts to a new location when copied or moved

Row appears horizontally in a worksheet and are identified by numbers

Show Formulas: a hotkey that automatically shows the formulas

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download