click below
click below
Normal Size Small Size show me how
Arkansas CBA Unit 3
Question | Answer |
---|---|
absolute cell reference | does not adjust to the new cell location when copied or moved |
active cell | cell that is ready for data entry |
alignment | position of data within a cell |
argument | value, cell reference, range, or text that acts as an operand in a function formula |
ascending | sort order that arranges text or numbers from A to Z, smallest to largest, or earliest to latest |
autosum | function that automatically adds the values in the cells directly above or to the left of the active cell |
AVERAGE | returns the average (arithmetic means) of its arguments |
cell | the space formed by the intersection of a row and column; the basic unit of a worksheet |
cell reference | unique identifier for a cell which is formed by combining the cell's column letter and row number |
chart/graph | graphic representation of values and their relationships |
column | vertical group of cells in a worksheet identified by letters |
column chart | chart that uses bars of varying height to illustrate values in a worksheet |
COUNT | returns the number of cells in a range that contains numbers |
descending | sort order that arranges text or numbers from Z to A, largest to smallest, or latest to earliest |
fill | to copy a cell's contents and/or formatting into an adjacent cell or range |
format | arranging the shape, 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 |
freeze | keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls |
function | a prewritten formula that makes it easy to perform common calculations |
label | alphanumeric text that will not be used in calculations |
line chart | chart that uses points connected by a line to illustrate values in a worksheet |
MAX | returns the largest value in a set of values |
MIN | returns the smallest values in a set of values |
mixed cell reference | contains both relative and absolute references |
operand | number or cell reference used in a formula |
operator | symbol that indicates what mathematical operation to perform on the operands |
order of operation | mathematical rules used for calculating the value of a formula |
pie chart | a chart that shows the relationship of a part to a whole |
range | selected group of cells on a worksheet |
relative cell reference | adjusts to a new location when copied or moved |
row | a horizontal group of cells in a worksheet identified by numbers |
sort | to arrange a list of words or numbers in ascending or descending order |
spreadsheet | a grid of rows and columns containing numbers, text, and formulas used to perform calculations |
SUM | adds all the numbers in a range of cells |
value | numeric characters that can be used in a calculation |
what-if analysis | process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet |
workbook | a collection of related worksheets |
worksheet | the workspace made up of columns and rows where data is entered to create an electronic spreadsheet |