Spreadsheet Notes

Spreadsheet Notes

Glossary:

Spreadsheet: A grid of rows and columns containing numbers and text that allows the user to manage, predict, and present information. An electronic spreadsheet is a computer application program that can also hold formulas in a cell that serve as a calculator. These formulas allow the electronic spreadsheet to perform calculations much faster and more accurately that spreadsheets created with pencil, paper, and calculator. An electronic spreadsheet is a computer application program that can also hold formulas in a cell that serve as a calculator. These formulas allow the electronic spreadsheet to perform calculations much faster and more accurately that spreadsheets created with pencil, paper, and calculator.

Formula Bar: Appears directly below the toolbar on the spreadsheet. On the far left side of the Formula Bar is the cell reference box that identifies the active cell.

Row: Horizontal lines of data across the spreadsheet that are identified by numbers on the left side of the spreadsheet window.

Cell: The intersection of a row and a column on a spreadsheet that is identified by a cell reference, the column letter and the row number (C2, E8, D1).

Column: Vertical lines of data in a spreadsheet that are identified by letters at the top of the spreadsheet window. (A, B, C, AB, AC, AD....).

Range: A selected group of cells that touch each other and form a rectangle. Operations can be performed on a range of cell.; A defined block of cells on a spreadsheet.

Enter: type in or record data in a spreadsheet.

Label: text symbols, dates or numbers(not used in calculations).

Values: a number that is entered on a spreadsheet and used for calculations.

Edit: to change the original entry in a spreadsheet.

Formula: Arthmetic equation with symbols(+-*/) for mathematical operations: A3+B3-C3*4

Function: Functions create shortcut formulas for the user: Sum (auto addition) and Avg (auto averaging of numbers).; A special formula that does not use operators to calculate a result

Operand: a number, cell reference, or field name used in a calculation in the formulas of spreadsheets or databases; in a database the operands are field names.

Operator: Tells Works what to do with the operands in a formula.

Order of Operation: The sequence used to calculate the value of a formula.

Order of Operations
Parenthesis
Exponents ^
Multiplication *
Division /
Addition +
Subtraction -

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

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

Mixed Cell Reference: A cell reference containing both relative and absolute references
_________________________________________________________________________________________

Advantages of Computer Spreadsheet:

Can answer, "What is? " (determines current information)