click below
click below
Normal Size Small Size show me how
spreadsheet 1
vocab
| Question | Answer |
|---|---|
| a grid of rows and columns that can store and manipulate data | spreadsheet |
| Spreadsheets are divided into _____ and ______ | rows and columns |
| Data is stored in the intersection of these rows and columns | cells |
| the entry point of a spreadsheet | highlight |
| a cell that is currently available for use | active cell |
| an area on the spreadsheet that identifies the location of the active cell | cell reference block (name box) |
| the line in a spreadsheet where you can make changes to data in a cell | edit line |
| the line in a spreadsheet where you can enter data in a cell | entry line |
| the line in a spreadsheet where you can enter a formula in a cell | formula bar |
| a block of continuous cells that can be manipulated together | range |
| vertical and are identified by letters | columns |
| horizontal and are identified by numbers | rows |
| three types of data | values, labels, formulas |
| data that appear in the form of numbers | values |
| data that appear in alphabetic form | labels |
| mathematical expressions that use values in a spreadsheet in calculations | formulas |
| a reference to a cell in a formula that will not adjust when it is copied from one cell to another | absolute cell reference |
| specials formulas that do not use operators to calculate a result | functions |
| (+-*/) are symbols that indicate what math function will be performed | math operators |
| numbers or cell references used in a formula | operands |
| list the order of operations | PEMDAS- parentheses, exponents, multiply, divide. add, subtract |