Excel Units 1-2
Excel Units 3-5
Excel Units 6 & 8
Access
Current Events
100
Worksheet
What is one spreadsheet in a workbook ?
100
Freezing
How you keep row or column titles on the screen no matter where you scroll in the worksheet ?
100
Conditional Formatting
What is highlighting worksheet data by changing the LOOK of data that meet a SPECIFIED CRITERIA ?
100
primary key
What is a unique field for each record.
100
Memorial Day
What is the next major US Holiday commerating men and women who served in the US armed forces ?
200
A grid of rows and columns in which you enter text, numbers, formulas and it calculates the results.
What is spreadsheet
200
Command that divides the screen into tow or four parts.
What is splitting ?
200
filter
What is displaying a subset of the data that meets certain criteria - temporarily hiding the rows or columns that don't meet the specified criteria ?
200
database
What is a collection of organized data that allows access, retrieval, and use of data ?
200
Owner of Charlotte hornest gets married
What did Michael Jordin do recently ?
300
a numeric data that is entered into a cell.
What is a value ?
300
relative
When a cell reference adjusts the row and column to its new location when copied or moved.
300
templates
What is a pre-designed workbook files that you can use as the basis or model for new workbooks ?
300
table
What is the first object created in a database that stores data in rows and columns ?
300
Francis XVII
Who is newest Pope ?
400
Autofit
What is an Excel feature that will automatically size a cell to accommodate the longest entry without wasting space. ?
400
*, +, -
What are operators ?
400
cropping
What is trimming off the edges of a picture leaving an inner section ?
400
Records
What are a complete set of data in a table - a collection of fields that appear as a row in a database ?
400
Uncle Si
Who is the crazy uncle on Duck Dynasty ?
500
general format
What is the default format for data in a cell ?
500
=sum(round(B5:B35))
What is a nested function
500
scatter chart
What is the chart that shows the relationship between two categories of data as a set of dots with or without lines.
500
report
What is a database object that is the best way to summarize and print data ?
500
Kim Jong-il
Who is the leader of North Korea ?
M
e
n
u