Question 1

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 2

A _____ is a saved object within the database, whereas a _____ is temporary.

Accepted Answer

A)  criterion; wildcard 
B)  field; record 
C)  query; filter 
D)  selection; form 
A)  criterion; wildcard 
B)  field; record 
C)  query; filter 
D)  selection; form

Question 3

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

Accepted Answer

False - To

Question 4

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following can you change when formatting a table?

Accepted Answer

A)  number of rows 
B)  page numbers 
C)  number of columns 
D)  background color 
A)  number of rows 
B)  page numbers 
C)  number of columns 
D)  background color

Question 6

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

Accepted Answer

False - many
False -

Question 7

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 8

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following are examples of correct criteria syntax? Select all the options that apply.

Accepted Answer

A)  = #1/1/2021# 
C)  < "Anderson" 
D)  <= 33.50 
A)  = #1/1/2021# 
C)  < "Anderson" 
D)  <= 33.50

Question 10

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

Accepted Answer

A)  Look in arrow 
B)  Match arrow 
C)  Search Fields as Formatted check box 
D)  Match Case check box 
A)  Look in arrow 
B)  Match arrow 
C)  Search Fields as Formatted check box 
D)  Match Case check box

Question 11

Before you close a query datasheet, you must save your changes to the data.

Accepted Answer

A) True 
 B)False

Question 12

What are you doing when you enter data into a subdatasheet?

Accepted Answer

A)  You are entering properties for the fields. 
B)  You are creating an alternate view of the data. 
C)  You are enforcing referential integrity. 
D)  You are entering records in the related table. 
A)  You are entering properties for the fields. 
B)  You are creating an alternate view of the data. 
C)  You are enforcing referential integrity. 
D)  You are entering records in the related table.

Question 13

What criterion would you use to find numbers greater than or equal to 100?

Accepted Answer

A)  100 
C)  >+100 
D)  >=100 
A)  100 
C)  >+100 
D)  >=100

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Query Design view presents the fields you can use for a query in small windows called field _____.

Accepted Answer

A)  categories 
B)  filters 
C)  properties 
D)  lists 
A)  categories 
B)  filters 
C)  properties 
D)  lists

Question 16

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 17

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 18

Add a Number field to a table to store values that represent money.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

Accepted Answer

A) True 
 B)False

To filter for comparative data, use the _____ feature.

A _ is a saved object within the database, whereas a _ is temporary.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

Which of the following can you change when formatting a table?

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

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

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

Before you close a query datasheet, you must save your changes to the data.

What are you doing when you enter data into a subdatasheet?

What criterion would you use to find numbers greater than or equal to 100?

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

Query Design view presents the fields you can use for a query in small windows called field _____.

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

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

Add a Number field to a table to store values that represent money.

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?

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

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

To filter for comparative data, use the _____ feature.

A _____ is a saved object within the database, whereas a _____ is temporary.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

Which of the following can you change when formatting a table?

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

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

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

Before you close a query datasheet, you must save your changes to the data.

What are you doing when you enter data into a subdatasheet?

What criterion would you use to find numbers greater than or equal to 100?

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

Query Design view presents the fields you can use for a query in small windows called field _____.

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

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

Add a Number field to a table to store values that represent money.

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?

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

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

A _ is a saved object within the database, whereas a _ is temporary.