How can we help?

You can also find more resources in our Help Center.

22 terms

NC Computer Apps I, 4.01 Spreadsheet Components

STUDY
PLAY
Workbook
a file which contains one or more spreadsheets.
Spreadsheet
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.
Cells
individual locations on a spreadsheet.
Cell address
refers to one specific location, such as A4.
Cell range
refers to a group of adjacent cells, such as A4:A16.
Column
refers to all of the contents in a vertical range of cells of the spreadsheet.
Row
refers to all of the contents in a horizontal range of cells.
Cell data
classified according to its intended purpose.
Label
used for cells that contain text or for numbers that will not be used in calculations.
Value
indicates that the data has the potential to be used in calculations.
Formula
instructs the software to perform a calculation.
Order of Operations
Calculations are performed according to this
Basic function
a shortcut for a formula.
Cell reference
indicates a cell's location and provides instructions for how cell data is copied or used in calculations.
Relative Cell Reference
cell value changes as the formula is copied
Absolute Cell Reference
cell value remains static when copied to other locations
Mixed Cell Reference
combination of an absolute and a relative cell
Parentheses
control the Order of Operations
Sum
adds the range of cells
Average
determines the average of the range of cells
Maximum
finds the highest number in the range of cells
Minimum
finds the lowest number in the range of cells