Question 1

The easiest way to filter the records for an exact match is to use the _____ feature.

Accepted Answer

A)  Filter By Form 
B)  Advanced Filter 
C)  Find and Replace 
D)  Filter By Selection 
A)  Filter By Form 
B)  Advanced Filter 
C)  Find and Replace 
D)  Filter By Selection

Question 2

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

Accepted Answer

A) True 
 B)False

Question 3

How do you display the results of a query listed in the Navigation Pane?

Accepted Answer

A)  Right-click the query,and then click Design View on the shortcut menu. 
B)  Right-click the query,and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query,and then click the Open button in the Navigation Pane. 
A)  Right-click the query,and then click Design View on the shortcut menu. 
B)  Right-click the query,and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query,and then click the Open button in the Navigation Pane.

Question 4

How can you list the records in a query datasheet in A-Z order by CustomerName?

Accepted Answer

A)  Click a value in the CustomerName field,and then click the Descending button. 
B)  Click a value in the CustomerName field,and then click the Ascending button. 
C)  Click the Advanced button,and then click Filter By Form. 
D)  Click the CustomerName column heading. 
A)  Click a value in the CustomerName field,and then click the Descending button. 
B)  Click a value in the CustomerName field,and then click the Ascending button. 
C)  Click the Advanced button,and then click Filter By Form. 
D)  Click the CustomerName column heading.

Question 5

What can you add to a query datasheet to display statistics for a group of records?

Accepted Answer

A)  Statistics row 
B)  grouping field 
C)  Total row 
D)  calculated field 
A)  Statistics row 
B)  grouping field 
C)  Total row 
D)  calculated field

Question 6

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

Accepted Answer

A)  field size 
B)  font 
C)  background color 
D)  font color 
A)  field size 
B)  font 
C)  background color 
D)  font color

Question 7

To filter for comparative data,use the _____ feature.

Accepted Answer

A)  Filter By Selection 
B)  Filter By Form 
C)  Clear Filter 
D)  Calculate Data 
A)  Filter By Selection 
B)  Filter By Form 
C)  Clear Filter 
D)  Calculate Data

Question 8

What should you do before applying a new filter to a datasheet?

Accepted Answer

A)  Switch to Query Design view. 
B)  Change the sort order of the records. 
C)  Save the previous filters. 
D)  Clear all previous filters. 
A)  Switch to Query Design view. 
B)  Change the sort order of the records. 
C)  Save the previous filters. 
D)  Clear all previous filters.

Question 9

You can add fields to a form in Design view or _____.

Accepted Answer

A)  Layout view 
B)  Form view 
C)  Print Preview 
D)  Datasheet view 
A)  Layout view 
B)  Form view 
C)  Print Preview 
D)  Datasheet view

Question 10

To create a banded rows effect in a report,you _____.

Accepted Answer

A)  apply a table style to the report 
B)  set the alternate row color of a report section 
C)  insert a background image 
D)  change the column layout 
A)  apply a table style to the report 
B)  set the alternate row color of a report section 
C)  insert a background image 
D)  change the column layout

Question 11

What does the criterion <=200 mean?

Accepted Answer

A)  less than or equal to 200 
B)  less than 200 
C)  greater than or equal to 200 
D)  not equal to 200 
A)  less than or equal to 200 
B)  less than 200 
C)  greater than or equal to 200 
D)  not equal to 200

Question 12

In a datasheet,you can find data,but not replace it.

Accepted Answer

A) True 
 B)False

Question 13

What might you need to do after increasing the font size in a table datasheet?

Accepted Answer

A)  Change the field sizes in Table Design view. 
B)  Widen the columns. 
C)  Check the spelling of the data. 
D)  Reset table relationships. 
A)  Change the field sizes in Table Design view. 
B)  Widen the columns. 
C)  Check the spelling of the data. 
D)  Reset table relationships.

Question 14

You use the Field List to add fields to a form in Form Design view.

Accepted Answer

A) True 
 B)False

Question 15

To total the values in a SalesPrice field in Table Datasheet view,you click the Total cell in the SalesPrice column,click the arrow,and then click _____.

Accepted Answer

A)  Total 
B)  Sum 
C)  Count 
D)  Avg 
A)  Total 
B)  Sum 
C)  Count 
D)  Avg

Question 16

To apply the last filter you selected to a datasheet,you click the _____ button.

Accepted Answer

A)  Clear All Filters 
B)  Remove Filter 
C)  Toggle Filter 
D)  Repeat Filter 
A)  Clear All Filters 
B)  Remove Filter 
C)  Toggle Filter 
D)  Repeat Filter

Question 17

Which of the following statements describe a filter? Select all the options that apply.

Accepted Answer

A)  In a datasheet,a filter displays only those records that match criteria you specify. 
B)  Access saves filters when you click the Toggle Filter button. 
C)  A filter displays a temporary subset of records in the current datasheet. 
D)  A filter is not as powerful as a query. 
A)  In a datasheet,a filter displays only those records that match criteria you specify. 
B)  Access saves filters when you click the Toggle Filter button. 
C)  A filter displays a temporary subset of records in the current datasheet. 
D)  A filter is not as powerful as a query.

Question 18

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

Accepted Answer

A)  sort orders 
B)  listings 
C)  layouts 
D)  criteria 
A)  sort orders 
B)  listings 
C)  layouts 
D)  criteria

Question 19

A query is a temporary view of the data that is removed when you close the query in Query Design view.

Accepted Answer

A) True 
 B)False

Question 20

In a Jobs database that contains an Employers table related to a Positions table,what do you expect to find in the subdatasheets of the Employers table?

Accepted Answer

A)  the company name of each employer 
B)  the positions offered by each employer 
C)  details about the employer with the most positions 
D)  the names of employers offering no positions 
A)  the company name of each employer 
B)  the positions offered by each employer 
C)  details about the employer with the most positions 
D)  the names of employers offering no positions

The easiest way to filter the records for an exact match is to use the _____ feature.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

How do you display the results of a query listed in the Navigation Pane?

How can you list the records in a query datasheet in A-Z order by CustomerName?

What can you add to a query datasheet to display statistics for a group of records?

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

To filter for comparative data,use the _____ feature.

What should you do before applying a new filter to a datasheet?

You can add fields to a form in Design view or _____.

To create a banded rows effect in a report,you _____.

What does the criterion <=200 mean?

In a datasheet,you can find data,but not replace it.

What might you need to do after increasing the font size in a table datasheet?

You use the Field List to add fields to a form in Form Design view.

To total the values in a SalesPrice field in Table Datasheet view,you click the Total cell in the SalesPrice column,click the arrow,and then click _____.

To apply the last filter you selected to a datasheet,you click the _____ button.

Which of the following statements describe a filter? Select all the options that apply.

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

A query is a temporary view of the data that is removed when you close the query in Query Design view.

In a Jobs database that contains an Employers table related to a Positions table,what do you expect to find in the subdatasheets of the Employers table?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 3: Performing Calculations With Formulas and Functions

The easiest way to filter the records for an exact match is to use the _____ feature.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

How do you display the results of a query listed in the Navigation Pane?

How can you list the records in a query datasheet in A-Z order by CustomerName?

What can you add to a query datasheet to display statistics for a group of records?

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

To filter for comparative data,use the _____ feature.

What should you do before applying a new filter to a datasheet?

You can add fields to a form in Design view or _____.

To create a banded rows effect in a report,you _____.

What does the criterion <=200 mean?

In a datasheet,you can find data,but not replace it.

What might you need to do after increasing the font size in a table datasheet?

You use the Field List to add fields to a form in Form Design view.

To total the values in a SalesPrice field in Table Datasheet view,you click the Total cell in the SalesPrice column,click the arrow,and then click _____.

To apply the last filter you selected to a datasheet,you click the _____ button.

Which of the following statements describe a filter? Select all the options that apply.

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

A query is a temporary view of the data that is removed when you close the query in Query Design view.

In a Jobs database that contains an Employers table related to a Positions table,what do you expect to find in the subdatasheets of the Employers table?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters