## NC Computer Apps 1, Unit 4.01 Terms

##### Created by:

mroettgen  on October 12, 2010

Pop out
No Messages

# NC Computer Apps 1, Unit 4.01 Terms

 WorkbookA file which contains one or more spreadsheets
1/30
Preview our new flashcards mode!

Order by

#### Definitions

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
Label 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.
Basic Function Shortcut for a formula
Formatting Applied to spreadsheet components for the purpose of organizing and clarifying information.
Sort Used to arrange data in alphabetical or chronological order
Freeze Panes Allows user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges.
Fill Series Used to fill a column or row with consecutive data.
Cell Address Refers to one specific location. Example C4
Cell Range Refers to a group of adjacent cells. Example A6:D10
Row All of the contents in a horizontal range of cells.
Column All of the contents in a vertical range of cells.
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 absoluteand a relative cell.
Order of Operations P (parentheses); E (exponents), M (multiplication), D (division), A (addition), S (subtraction)
Sum Function Adds a defined range of cells. Example =SUM(C4:C18)
Average Function Determines the average of a defined range of cells. Example =AVERAGE(C4:C18)
Maximum Function Finds the highest number in a defined range of cells. Example =MAX(C4:C18)
Minimum Function Finds the lowest number in a defined range of cells. =MIN(C4:C18)
Wrap Used to align multi-line text within a single cell.
Merge Used to combine two or more cells.
Primary Sort Indicates the primary sort range of data.
Secondary Sort Indicates the next range of data sorted.
Print Selection Used to print a portion of a spreadsheet.
Linkied When the target, usually a word document, is updated when the source document (spreadsheet) is edited or changed.
Embedded When the spreadsheet is converted into a graphic image (snapshot) and placed in the target document. The target document does not change when the source document changes.

### First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

### Set Champions

##### Scatter Champion

16.4 secs by doctorwhogeek91011

##### Space Race Champion

83,810 points by doctorwhogeek91011

### Completed “Learn” mode

doctorwhogeek91011