Spreadsheets - Lesson 3 & 4 Worksheet

Area above the worksheet in which you view, type, and edit cell entries.
Addres in a formula that refers to the same single cell in adjacent worksheets of the workbook; may be used to sum or average the contents of those cells.
Predefined formula that performs calculations on table cells.
Cell content beginning with an equals (=) sign that connects to a cell in another area of the same worksheet, a different worksheet, or a different workbook.
The cell is relative to the cell that cotnains the formula.
Identification which cell or range of cells contains the values to use in a formula.
Reference in a formula that always refers to the same cell, regardless of which cell teh formual is moved or copied to.
An example of this type of reference is $C1
Changing the value in one or more cells that are used in a formula to see the various results of the changes.
References within a formula that depend upon the results of that same formula. A cell that refers to its own value.
Feature common to several applications that appears when text is selected.
Preview how many formatting changes will look before actually issuing the command.
This allows you to offset entries from the edge of the cells to convey the hierarchy of entries within worksheets.
Ability to combine cells.
Ability to undo the merged cells.
Allows to copy the formatting from one cell to another without copying the contents.
Ability to apply formatting to cells based on meeting criteria that you set.
Set of formatting selections that can be applied to a document; including colors, graphic elements, and fotns all desinged to work well together.
Preset design consisting of color scheme, text formatting, and placeholder positions.
Contains six (6) tabs that allow you to apply different aspects to your worksheet: number, alignment, font, border, fill, and protection.