1. What distinguishes an excel database from an excel form?

 The tabular format.
 An excel form contains no data.
 The way they look.
 An excel database automatically formats itself.

2. When sorting in an excel database and you want the sorted information to maintain relative formation what must you do?

 Select all the data.
Select only the data you want sorted.
Select only the data you don't want sorted, then choose the sort option.
All of the above.

3. How does one create a data form?

 Open the file menu select new, click the tab that contains the template for the form and then double click the template.
 Open the format menu, select the data form sub menu.
 Left click the blank sheet icon.
None of the above.

4.  All of the following are auto filter options except?

 Blanks: display only rows that contain a blank cell in the column.
 Non blanks: display only rows that contain a value in a column.
 All: display all rows
There are no exceptions all of the above are auto filter options.

5. Which of the following is not a search method?

 In a open data form choose the criteria button, enter the criteria.
  auto filter and then select criteria
 Open the tools menu, choose share workbook, then the search conditions submenu, enter desired entries, and choose mark.
 From the edit menu choose Find and then enter criteria.

6. Your excel workbook can be edited if you don't open the tools menu and select protection, then choose protect sheet, type a password, click ok, and retype the password in the confirm password dialogue box. 

  True
 False

7. A macro is a series of commands and functions stored in a visual basic module and can be run whenever you need to run the task. 

 True
  False

8. If you make a mistake while recording a macro the corrections you make are?

 Recorded also
 Unimportant, because the program automatically fixed it.
 Unimportant, because once you make a mistake you can't fix it.
 Not recorded

9. How does one run a macro?

 Open the tools menu, select macro, enter the macro name you want, select run.
 Once macros are created the program runs them automatically.
 When the macro is supposed to run should be programmed in the macro itself.
 The macro shortcut on the toolbar

10. What Excel options helps you create a pivot table report?

The chart wizard
 Troubleshoot
Hyperlinks
The pivot chart wizard