click below
click below
Normal Size Small Size show me how
Spreadsheet Notes
vocab
Term | Definition |
---|---|
Spreadsheet | Grid of rows and columns that can store and manipulate data |
Columns | vertical and identified by letters |
Rows | horizontal and identified by numbers |
Cells | data is stored in the intersection of the rows and columns |
Quick access bar | (located on top the left hand corner of the screen) |
Active cell | that is currently available for use. |
Cell reference box | (name box) is an area on the spreadsheet that identifies the location of the active cell. |
edit line | is the line in the spreadsheet where you can make changes to a data in a cell. |
Entry line | is the line in the spreadsheet where you can enter data into a cell. |
formula bar | is the line in a spreadsheet where you can enter a formula into a cell. |
Rang | is a block of continuous cells that can be manipulated together. |
values | are data that appear in the form of numbers |
Labels | are data that appears in alphabetic form. |
Formulas | are mathematical expressions that use formulas in a spreadsheet in calculations. |
Relative cell reference | is a reference to a cell in a formula that will adjust when it is copied from one cell to another. |
Function | are special formulas that do not operate to calculate a result. |
Math Operators | (+-*/) are symbols that indicate what math function will be performed. |
Operands | are numbers or cell references used in a cell formula |