CS100 Lecture Notes - Lecture 2: Bob Frankston, File Descriptor, B Cell
Document Summary
Absolute address: cell address does not change when copied or filled into another cell, used to keep value constant. Active cell: single cell inside the current selection, the selection may contain more than one cell, but only 1 cell is the. Cell: intersection of a column and a row within the grid. Cell address: unique identification of a cell through combination of columns and rows within the grid in which it is located. Cell reference: identify the location a cell or range of cells are in a worksheet. Column vertical grids along the worksheets, represented by letters/with letter headings. Fill (right, left, up, down): to fill/copy data from the active cell into its adjacent cells through dragging the fill handle. Formula: an expression which calculates the value of a cell that contains values, references to cells, defined names and functions (not every formula includes a function) Formula bar: displays data/formula stored in the active cell.