Question 1

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 2

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 3

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

Accepted Answer

False - descending
F

Question 4

What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?

Accepted Answer

A)  [DiscountPrice]: Price-10 
B)  [Price]-10=DiscountPrice 
C)  DiscountPrice: [Price]-10 
D)  DiscountPrice: [Price]*10 
A)  [DiscountPrice]: Price-10 
B)  [Price]-10=DiscountPrice 
C)  DiscountPrice: [Price]-10 
D)  DiscountPrice: [Price]*10

Question 5

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Accepted Answer

A)  select query 
B)  subtotal query 
C)  statistics query 
D)  summary query 
A)  select query 
B)  subtotal query 
C)  statistics query 
D)  summary query

Question 6

Which of the following statements describe Query Design view? Select all the options that apply.

Accepted Answer

A)  Field lists appear in the upper pane of Query Design view. 
B)  Query Design view shows the SQL code for the query. 
C)  The query design grid provides a way to sort records. 
D)  Query Design view lets you modify an existing query. 
A)  Field lists appear in the upper pane of Query Design view. 
B)  Query Design view shows the SQL code for the query. 
C)  The query design grid provides a way to sort records. 
D)  Query Design view lets you modify an existing query.

Question 7

The Alternate Background Color command changes the background color of alternate records in a selected section.

Accepted Answer

False - Ro

Question 8

Use Query Design view to display the results of a query.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following statements are true about subdatasheets? Select all the options that apply.

Accepted Answer

A)  They appear for a table on the "one" side of a one-to-many relationship. 
B)  You can click the expand button to view the records in a subdatasheet. 
C)  You can click the Sub button to display the subdatasheets in any table. 
D)  You can use a subdatasheet to enter new records. 
A)  They appear for a table on the "one" side of a one-to-many relationship. 
B)  You can click the expand button to view the records in a subdatasheet. 
C)  You can click the Sub button to display the subdatasheets in any table. 
D)  You can use a subdatasheet to enter new records.

A query is a temporary view of the data that is removed when you close the query in Query 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 _____.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Which of the following statements describe Query Design view? Select all the options that apply.

The Alternate Background Color command changes the background color of alternate records in a selected section.

Use Query Design view to display the results of a query.

Which of the following statements are true about subdatasheets? Select all the options that apply.

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

A query is a temporary view of the data that is removed when you close the query in Query 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 _____.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Which of the following statements describe Query Design view? Select all the options that apply.

The Alternate Background Color command changes the background color of alternate records in a selected section.

Use Query Design view to display the results of a query.

Which of the following statements are true about subdatasheets? Select all the options that apply.

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