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

Objective 4.00 Spreadsheets

AB
EmbedTo permanently place an object in a file
LinkTo place an object in a file that will change when the original changes
FillCopying a fomula so you don't have to type it in each cell
Freeze PanesKeeping row and column titles visible
AutosumShortcut to adding a range of cells
Merge CellsTo combine multiple cells into one
Split CellsTo divide one cell into multiple cells
Wrap textMaking cell data show as 2 lines instead of one
BorderA dark line around a cell or group of cells
CurrencyHow money appears in a cell
CountGives the total number of cells in a group.
SortTo arrange data
MaxThe largest number in a range
MinThe smallest number of cells in a range
SumThe total of a range of cells
AverageThe total of a range of cells divided by the number of cells
IFA function that bases it's answer on whether certain criteria is met.
Days 360This will subtract the number of days left in a period
LookupProviding a list of options to choose from
AbsoluteWill not change
RelativeIt may change
Mixed referenceContains both Absolute and Relative values
NowCurrent date
RangeA group of cells
FormulaMathematical equation
FunctionA shortcut formula
ValueA number used in a calculation
LabelA number or text NOT used in a calculation


Stuart W Cramer High School
NC

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