Excel Basics
Excel Advanced
Access Basics
Access Advanced
Expert
100
This is the term given to the individual "rectangles" in an Excel worksheet.
What is a cell?
100
This option allows you to change the settings of the printed worksheet such as the margins.
What is page setup?
100
This is defined as a row in a database.
What is a record?
100
This is the field setting you use for cells on which you wish to perform a calculation.
What is a number?
100
This is the name of a software program that allows for editing, storing, and updating information.
What is a database management system?
200
This is the name of a calculation in Excel.
What is a formula?
200
This option allows you to join two cells together.
What is merge and center?
200
This is defined as a column in a database.
What is a field?
200
This helps you easily create an object in a database by asking a series of questions.
What is a wizard?
200
This term refers to a group of close cells (usually referred to in a formula).
What is a range?
300
All formulas begin with this.
What is a equals sign (=).
300
This function adds a selection of cells.
What is the AutoSum button?
300
This is a field which uniquely identifies a record.
What is a primary key?
300
This is the "view" you use when you are entering field names for a table.
What is design view?
300
In Excel, you can use this tool to copy formulas to adjacent cells.
What is a fill handle?
400
This is a collection of related worksheets.
What is a workbook?
400
This is the mathematical process Excel uses to calculate an equation.
What are the order of evaluations (operations)?
400
This is a field which uniquely identifies a record.
What is a primary key?
400
Records sorted from A to Z are said to sorted in this order.
What is ascending?
400
This is the name of a view in which data is ready to be entered into a table.
What is a datasheet view?
500
What is a footer?
This is a place in an Excel that allows you to add text at the bottom of a printed worksheet.
500
This is a reference to a cell which does not change when copied from cell to cell.
What is an absolute reference?
500
This is the term that refers to organized data.
What is information?
500
This is the name of the place in a query where you define your "search terms."
What is a criteria?
500
This is a function of a database that allows it to run pre-determined code (sometimes for malicious intent).
What is a macro?
M
e
n
u