Show:
Chapter 5
Chapter 6
Chapter 7
Chapter 9
Chapter 10
100
An Excel file
What is a workbook?
100
Type of sort that sorts small to big.
What is ascending sort?
100
Visual representation of worksheet data
What is a chart?
100
A unique identifier that guarantees no two records are exactly the same
What is a primary key?
100
Question, when answered, filters out the records/fields that answer the question
What is a query?
200
The column letter and row number of a single cell.
What is a cell reference?
200
The symbol placed in front of the letter and number in an absolute reference.
What is a $ (dollar sign)?
200
Chart best for charting data percentage of a whole
What is a pie chart?
200
A collection of information about people, places, or events with something in common
What is a database?
200
Wildcard you use to match any number of characters before or after that string
What is an * (asterisk)?
300
Two or more selected cells
What is a range?
300
When copied this reference changes based on the direction copied
What is a relative reference?
300
Chart most useful in comparing differences between values
What is a bar chart?
300
A category of information
What is a field?
300
Wildcard you use to match any one character at the location of it
What is a ? (question mark)?
400
List the three types of data in Excel
What are labels, values, and dates/times?
400
This performs a calculation that results in a single value.
What is a function?
400
Chart useful for displaying the differences of data over time
What is a line chart?
400
All the information about a person, place or event
What is a record?
400
Allows you to define and control how data is input for certain data types
What is an input mask?
500
This is where the contents of the active cell are displayed
What is the formula bar?
500
List the five elements of a function in order
What are equal sign, name of function, left parentheses, arguments, and right parentheses?
500
This describes what is charted
What is a chart title?
500
These two things must happen to join tables
What is have a common field name and the name must be the primary key in one of the tables?
500
Type of rule that allows us to restrict data entries to specified values
What is a validation rule?