Show:
Excel Basics
Excel
Access Basics
Access
Other
100
A spreadsheet that may contain data, values, formulas, and/or charts.
What is a worksheet?
100
When a specific cell reference does not change.
What is absolute cell referencing?
100
A Microsoft database that works primarily from storage.
What is Microsoft Access?
100
The feature that fixes problems due to inefficient file storage and growth of a database.
What is compact and repair?
100
The online technology we used to work on the group project?
What is Microsoft Office Live?
200
Used to start all Excel formulas.
What is an =?
200
The Excel function that obtains its time and date from the computer's clock.
What is =NOW()?
200
An Access object that is similar to an Excel worksheet.
What is a table?
200
Selecting only the records that match pre-selected criteria.
What is filter by selection?
200
The online presentation software that allows you to use Flash to creatively tell stories with your presentations.
What is Prezi?
300
Used to copy formulas or finish a text series.
What is the fill handle?
300
The command on the Layout tab to join two or more cells together.
What is merge cells?
300
An Access object used to find a group of people who live in the same state in a table.
What is a query?
300
Used to avoid data entry errors by restricting what can be entered.
What are data validation rules?
300
Google’s alternative to Microsoft Excel.
What is Google Spreadsheets?
400
A predefined formula.
What is a function?
400
To see your employee sales from the largest amount to the smallest, sort the table with this.
What is descending?
400
A view used to create and modify the fields in a table.
What is design view?
400
Requires that all business records be saved for a period of five years and be made available to the SEC upon request.
What is the Sarbanes Oxley Act (SOX)?
400
Zoho’s alternative to Microsoft Access.
What is Zoho Creator?
500
The cell you are working in, where data will be input.
What is the active cell?
500
Visually displays comparisons of data vertically.
What is a column chart?
500
A field that identifies each record as being unique.
What is the primary key?
500
Ensures that the data in a relational database maintains consistency when the data changes.
What is referential integrity?
500
The presentation software that Al Gore used in the movie “An Inconvenient Truth.”
What is Mac's Keynote?