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 |