click below
click below
Normal Size Small Size show me how
Spreadsheet Hall LRS
Excel Chapter 1 and 2
Question | Answer |
---|---|
active cell | A selected worksheet cell that is ready for data. |
alignment | The position of data within a cell. |
autosum | A function that automatically adds the values in the cells directly above or to the left of the active cell. |
AVERAGE | Returns the average of its arguments. |
cell | The space formed by the intersection of a row and column; the basic unit of a worksheet. |
cell reference | A unique identifier for a cell which is formed by combining the cell's column letter and row number. |
chart/graph | A graphic representation of values and their relationships; pie, line, column, bar, scattered |
column | A vertical group of cells in a worksheet identified by letters. |
column chart | A chart that uses bars of varying height to illustrate values in a worksheet. |
fill | To copy a cell's contents and/or formatting into an adjacent cell or range. |
format | Arranging the shpe, size, type, and general makeup of a cell or group of cells. |
formula | An equation that calculates a new value using values currently on a worksheet. |
function | A prewritten formula that makes it easy to perform common calculations. |
MAX | Return the largest value in a set of values. |
MIN | Returns the smallest value in a set of values. |
pie chart | A chart that shows the relationship of a part to a whole. |
range | A selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon. |
relative cell reference | A cell reference that adjusts to a new location when copied or moved. |
row | A horizontal group of cells in a worksheet identified by numbers. |
spreadsheet | A grid of rows and columns containing numbers, text, and formulas used to perform calculations. |
workbook | A collection of related worksheets. |
worksheet | The workspace made up of columns and row where data is entered to create an electronic spreadsheet. |