Database
Single column in a table that stores data
Field
Used to add identifying information to a spreadsheet, including page number, title of company, date, creator name etc.
What are headers or footers?
This is the symbol that instructs the spreadsheet software to perform a calculation
What is an equal sign?
This is a shortcut for a formula
What is a function?
Points (x2)
What type of charts are best for the comparison of data
Bar Chart, Column Chart
Collection of related fields.
record
These are the three main types of justification
What are left, right, and center?
This classification is used for numbers that may be used in calculations
What are values?
This function adds a range of cells
What is SUM?
This formatting feature is used to combine two or more cells
Determine the amount of character that can fit in a field
Field Size
How we identity a cell, by the column letter and row number
What is a cell reference, or cell address?
Points (x2)
These are the four operators used in spreadsheet calculations
What is addition, subtraction, division, and multiplication?
What is a colon?
Points (x2)
When ##### appears in a cell, it indicates this error
What is too small of a column width?
Unique identifier for each record in a table.
Primary Key
Points (x2)
This is the default justification for values
What is right?
What is the formula to add the contents of C2 to D5.
= C2+D5
What function is used to find the lowest in a range of cells
=MIN
Write the following function to find the highest value in the cell range B1:B10.
=MAX(B1:B10)
Points (x2)
Finds records in a database according to criteria specified.
Query
An individual location in a spreadsheet- the intersection of a column and row
What is a cell?
This is used to create a continuation of the data series
Fill Handle
Points (x2)
Write the following formula: Multiply A6 by C6.
What is =A6*C6
Write the following formula- minimum value of the cell range A2:A12
What is =MIN(A2:A12)