Java Games: Flashcards, matching, concentration, and word search.

4.01

Spreadsheets

AB
Workbookis a file which contains one or more spreadsheets
Spreadsheetis an arangement of cells in columns and rows used to organize, analyze, calculate,and report information.
Cellsindividual locations on a spreadsheet
Labelused for cells that contain text or for numbers that wil not be used in calculations
Valueclassification indicates that the data has the potential to be used in calculations
Formulainstructs the software to perform a calculation
Order of operationsCalculations are performed according to
Cell Referenceindicates a cell's location
Relativecell value changes as the formula is copied
Absolutecell value remains stratic when copied to other locations
Mixedcombination of an absolute and relative cell
ParenthesesControls the Order of Operations
Conditions or CriteriaTells the function how to calculate the results and what data to use
FormattingApplied to spreadsheet components for the purpose of organizing and clarifying information.
LeftBy default, cells formatted as labels are ___ justified
Indentis a format applied to cell data to emphasize subcategories
RightBy default, cells formatted as values are ______ justified
CenterFormatting usually applied to titles and column headings
WrapIs used to align multi-line text within a cell
MergeIs used to combine two or more cells
Column widthis adjusted to fit the longest entry
SortUsed to arrange data in alphabetical or chronological order
Primary SortIndicates the primary sort range of data
Secondary SortIndicates the next range
Freeze PanesAllows the user to work in multiple areas of a large spreadsheet
Fill SeriesIs used to fill a column or row with consecutive data
PrintIs used to provide a hard copy
Print PreviewUsed to view how data is represented on paper
Print a selectionUsed to print a portion of a spreadsheet
Linking and EmbeddingIs used to integrate spreadsheet data with other software applications


Teacher
Northampton County High School
Conway, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities