Search
Create
Log in
Sign up
Log in
Sign up
Arkansas CBA Unit 3: Spreadsheet
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (38)
Absolute cell reference
cell reference that does not adjust to the new cell location when copied or moved
Active cell
a selected worksheet cell that is ready for data entry
Alignment
the 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 arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
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 (arithmetic means) of its arguments
Cell
the space formed by the intersection of a row and a 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
Count
returns the number of cells in a range that contains numbers
Descending
sort order arranging 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
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 Operations
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 adjust 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
;