Question 1

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 B

Question 2

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 B

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

What can you do when a report has blank pages in Print Preview?

Accepted Answer

A)  Delete the blank page. 
B)  Click the Margins button on the Print Preview tab to change the report margins. 
C)  Insert a page break control. 
D)  Click the Zoom button on the Print Preview tab to hide the blank pages. 
A)  Delete the blank page. 
B)  Click the Margins button on the Print Preview tab to change the report margins. 
C)  Insert a page break control. 
D)  Click the Zoom button on the Print Preview tab to hide the blank pages.

Question 8

Which of the following options are available on the navigation bar in Print Preview of a report? Select all the options that apply.

Accepted Answer

A)  Next Page 
B)  New Page 
C)  First Page 
D)  Last Page 
A)  Next Page 
B)  New Page 
C)  First Page 
D)  Last Page

Question 9

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 10

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

Accepted Answer

A)  underlining 
B)  text in the label 
C)  outline color and style 
D)  background color 
A)  underlining 
B)  text in the label 
C)  outline color and style 
D)  background color

Question 11

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 12

You can use the Format property to display dates in a report using a Short Date format.

Accepted Answer

A) True 
 B)False

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 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 15

What property should you set to have the Department header section appear at the top of every printed page?

Accepted Answer

A)  Repeat Section 
B)  Print Section 
C)  Every Page 
D)  After Section 
A)  Repeat Section 
B)  Print Section 
C)  Every Page 
D)  After Section

Question 16

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Accepted Answer

A)  Anchoring 
B)  Size/Space 
C)  Control Margins 
D)  Align 
A)  Anchoring 
B)  Size/Space 
C)  Control Margins 
D)  Align

Question 17

Which report section is most commonly used for dates and page numbers?

Accepted Answer

A)  Page Header 
B)  Detail 
C)  Report Footer 
D)  Group Header 
A)  Page Header 
B)  Detail 
C)  Report Footer 
D)  Group Header

Question 18

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 19

You select a control layout so that you can move or change the controls as a group.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.

Accepted Answer

A)  Short Date 
B)  General Date 
C)  Long Date 
D)  Year Only Date 
A)  Short Date 
B)  General Date 
C)  Long Date 
D)  Year Only Date

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

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?

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

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

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.

What can you do when a report has blank pages in Print Preview?

Which of the following options are available on the navigation bar in Print Preview of a report? Select all the options that apply.

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

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

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

You can use the Format property to display dates in a report using a Short Date format.

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

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

What property should you set to have the Department header section appear at the top of every printed page?

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Which report section is most commonly used for dates and page numbers?

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

You select a control layout so that you can move or change the controls as a group.

Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.

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

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

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?

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

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

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.

What can you do when a report has blank pages in Print Preview?

Which of the following options are available on the navigation bar in Print Preview of a report? Select all the options that apply.

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

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

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

You can use the Format property to display dates in a report using a Short Date format.

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

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

What property should you set to have the Department header section appear at the top of every printed page?

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Which report section is most commonly used for dates and page numbers?

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

You select a control layout so that you can move or change the controls as a group.

Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.

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