Question 1

To add a sort to a report in Report Design view, you use the _____ button.
A) Header & Footer
B)

Accepted Answer

C

Question 2

When you select a control in Form Design view, you can use _____ to resize the control.

Accepted Answer

A)  arrow keys 
B)  conditional sizing 
C)  resizing handles 
D)  smart guides 
A)  arrow keys 
B)  conditional sizing 
C)  resizing handles 
D)  smart guides C

Question 3

You use a toggle button on a form to _____.

Accepted Answer

A)  apply conditional formatting to the form 
B)  indicate a "yes" or "no" value 
C)  display a list of possible entries 
D)  provide tabbed pages of other controls 
A)  apply conditional formatting to the form 
B)  indicate a "yes" or "no" value 
C)  display a list of possible entries 
D)  provide tabbed pages of other controls B

Question 4

You can change the margins of a report using the Margins button on the Print Preview tab.

Accepted Answer

A) True 
 B)False

Question 5

If you want a query to select records for customers living in Ohio, which of the following fields should you add to the query design grid?

Accepted Answer

A)  Phone 
B)  State 
C)  OrderAmt 
D)  Street 
A)  Phone 
B)  State 
C)  OrderAmt 
D)  Street

Question 6

Which of the following actions selects all the report controls in Report Design view?

Accepted Answer

A)  Drag in the vertical ruler from the top to the bottom of the report. 
B)  Click each control in the report. 
C)  Double-click the report selector button. 
D)  Click a selector bar, press and hold the SHIFT key, and then click the other selector bars. 
A)  Drag in the vertical ruler from the top to the bottom of the report. 
B)  Click each control in the report. 
C)  Double-click the report selector button. 
D)  Click a selector bar, press and hold the SHIFT key, and then click the other selector bars.

Question 7

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

Accepted Answer

A)  click a control in the layout 
B)  click the Selection button on the Home tab 
C)  click the vertical ruler next to the layout 
D)  switch to Form view 
A)  click a control in the layout 
B)  click the Selection button on the Home tab 
C)  click the vertical ruler next to the layout 
D)  switch to Form view

Question 8

How do you align the right edges of selected controls in Form Design view?

Accepted Answer

A)  Click the Align Right button on the Home tab. 
B)  Click the Align button on the Form Design Tools Arrange tab, and then click Right. 
C)  Click the Size/Space button on the Form Design tools Arrange tab, and then click Right. 
D)  Click the Align button on the Form Design Tools Format tab. 
A)  Click the Align Right button on the Home tab. 
B)  Click the Align button on the Form Design Tools Arrange tab, and then click Right. 
C)  Click the Size/Space button on the Form Design tools Arrange tab, and then click Right. 
D)  Click the Align button on the Form Design Tools Format tab.

Question 9

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

Accepted Answer

A)  To Default 
B)  To Fit 
C)  To Tallest 
D)  To Widest 
A)  To Default 
B)  To Fit 
C)  To Tallest 
D)  To Widest

Question 10

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

Accepted Answer

A) True 
 B)False

Question 11

When you resize a label in Form Design view, _____.

Accepted Answer

A)  you do not see the changes until you switch to Form view 
B)  you disconnect the label from its text box 
C)  you resize the label in all the other views 
D)  you do not have to save the design change 
A)  you do not see the changes until you switch to Form view 
B)  you disconnect the label from its text box 
C)  you resize the label in all the other views 
D)  you do not have to save the design change

Question 12

To create a report based on an existing report named Clients, you can _____.

Accepted Answer

A)  create a blank report and then import the Clients report 
B)  use the Report Wizard to select the Clients report as the record source 
C)  create a blank report using the property sheet from the Clients report 
D)  copy the Clients report and then paste it into the database with a new name 
A)  create a blank report and then import the Clients report 
B)  use the Report Wizard to select the Clients report as the record source 
C)  create a blank report using the property sheet from the Clients report 
D)  copy the Clients report and then paste it into the database with a new name

Question 13

You can display page numbers on a report in a "Page 1 of 2" format.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following views provides the most options for creating and modifying a report?

Accepted Answer

A)  Report view 
B)  Print Preview 
C)  Report Design view 
D)  Report Layout view 
A)  Report view 
B)  Print Preview 
C)  Report Design view 
D)  Report Layout view

Question 15

You can use the _____ to apply the same formatting to multiple controls in a report.

Accepted Answer

A)  Conditional Formatter 
B)  Format Painter 
C)  Shape Effects tool 
D)  Report tool 
A)  Conditional Formatter 
B)  Format Painter 
C)  Shape Effects tool 
D)  Report tool

Question 16

After creating a report with the Report Wizard, you cannot add a sort to the report.

Accepted Answer

A) True 
 B)False

Question 17

How can you quickly add the date and time to a report in Report Design view?

Accepted Answer

A)  Add a calculated control containing the expression =DateAndTime(). 
B)  Click the Calendar button on the Design tab. 
C)  Right-click a report section, and then click Calendar Picker on the shortcut menu. 
D)  Click the Date and Time button on the Design tab. 
A)  Add a calculated control containing the expression =DateAndTime(). 
B)  Click the Calendar button on the Design tab. 
C)  Right-click a report section, and then click Calendar Picker on the shortcut menu. 
D)  Click the Date and Time button on the Design tab.

Question 18

When you delete a control from a form, you also delete the data it contains.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following pages numbers is displayed in the "Page N of M" format?

Accepted Answer

A)  Page 1 
B)  Page 1 of 5 
C)  1 of 5 
D)  Page 1/5 
A)  Page 1 
B)  Page 1 of 5 
C)  1 of 5 
D)  Page 1/5

Question 20

Report Design View gives you full control of all aspects of a report.

Accepted Answer

A) True 
 B)False

To add a sort to a report in Report Design view, you use the _____ button. A) Header & Footer B)

When you select a control in Form Design view, you can use _____ to resize the control.

You use a toggle button on a form to _____.

You can change the margins of a report using the Margins button on the Print Preview tab.

If you want a query to select records for customers living in Ohio, which of the following fields should you add to the query design grid?

Which of the following actions selects all the report controls in Report Design view?

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

How do you align the right edges of selected controls in Form Design view?

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

When you resize a label in Form Design view, _____.

To create a report based on an existing report named Clients, you can _____.

You can display page numbers on a report in a "Page 1 of 2" format.

Which of the following views provides the most options for creating and modifying a report?

You can use the _____ to apply the same formatting to multiple controls in a report.

After creating a report with the Report Wizard, you cannot add a sort to the report.

How can you quickly add the date and time to a report in Report Design view?

When you delete a control from a form, you also delete the data it contains.

Which of the following pages numbers is displayed in the "Page N of M" format?

Report Design View gives you full control of all aspects of a report.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 7: Summarizing Data With Pivottables

To add a sort to a report in Report Design view, you use the _____ button. A) Header & Footer B)

When you select a control in Form Design view, you can use _____ to resize the control.

You use a toggle button on a form to _____.

You can change the margins of a report using the Margins button on the Print Preview tab.

If you want a query to select records for customers living in Ohio, which of the following fields should you add to the query design grid?

Which of the following actions selects all the report controls in Report Design view?

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

How do you align the right edges of selected controls in Form Design view?

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

When you resize a label in Form Design view, _____.

To create a report based on an existing report named Clients, you can _____.

You can display page numbers on a report in a "Page 1 of 2" format.

Which of the following views provides the most options for creating and modifying a report?

You can use the _____ to apply the same formatting to multiple controls in a report.

After creating a report with the Report Wizard, you cannot add a sort to the report.

How can you quickly add the date and time to a report in Report Design view?

When you delete a control from a form, you also delete the data it contains.

Which of the following pages numbers is displayed in the "Page N of M" format?

Report Design View gives you full control of all aspects of a report.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters