excel vocab
Terms
undefined, object
copy deck
- the main document created when using Excel.
- workbook
- keeping a cell reference constant when copying a formula.
- absolute cell references
- a graphical presentation of data in a spreadsheet
- chart
- a logical statement that is made up of two values and a relational operator. The condition is either TRUE or FALSE for a cell
- condition
- a group of cells that are either in the same row or column
- range
- when copying formulas using auto fill, the row or column references change to match the row or column as you move from cell to cell
- relative references
- enters the system date into a spreadsheet
- NOW function
- the horizontal component of a spreadsheet. Rows are numbered
- rows
- formatting (color, font) that applies only when the value in a cell matches specified criteria
- conditional formatting
- a "page" within a workbook
- spreadsheet
- a quick and easy way to copy the contents of one cell (data or formulas) into another cell or range of cells
- Auto fill
- the values that you use with a function.
- arguments
- a function computes statistics. It takes a value or values, performs an operation and then returns a result.
- function
- the vertical component of a spreadsheet. Columns are lettered.
- columns
- a method that allows you to quickly format cells or groups of cells by applying the desired formatting from one location to another
- format painter button