click below
click below
Normal Size Small Size show me how
CBA Unit 3 Part 2
Second 1/2 of Vocabulary Terms and Definitions for Arkansas CBA Unit 3
| Term | Definition |
|---|---|
| Label | alphanumeric text that will not be used in calculations |
| Line chart | - a 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 value in a set of values |
| Mixed cell reference | a cell reference that contains both relative and absolute references |
| Operand | a number or cell reference used in a formula |
| Operator | a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/) |
| Order of operation | the 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 identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon |
| Relative cell reference | cell reference that 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 |