Exam 7: Summarizing Data With Pivottables
Exam 1: Getting Started With Excel94 Questions
Exam 2: Formatting Workbook Text and Data55 Questions
Exam 3: Performing Calculations With Formulas and Functions69 Questions
Exam 4: Analyzing and Charting Financial Data41 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks69 Questions
Exam 6: Managing Data With Data Tools120 Questions
Exam 7: Summarizing Data With Pivottables43 Questions
Exam 8: Performing What-If Analyses62 Questions
Exam 9: Exploring Financial Tools and Functions62 Questions
Exam 10: Analyzing Data With Business Intelligence Tools64 Questions
Exam 11: Exploring Pivottable Design88 Questions
Exam 12: Developing an Excel Application103 Questions
Select questions type
Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.
(Multiple Choice)
4.9/5
(32)
You select a control layout so that you can move or change the controls as a group.
(True/False)
4.9/5
(38)
To add totals to a report column in Report Design view, you create a calculated control.
(True/False)
5.0/5
(38)
In Report Design view, you add a field to a report using the _____.
(Multiple Choice)
4.8/5
(41)
Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?
(Multiple Choice)
4.8/5
(35)
Which of the following report controls can you format in bold?
(Multiple Choice)
4.8/5
(33)
Changing the title of a report in Report Layout view also changes the name of the report.
(True/False)
4.8/5
(34)
What can you do when a report has blank pages in Print Preview?
(Multiple Choice)
4.8/5
(34)
Which of the following are formatting properties you can apply to many report controls?
(Multiple Choice)
4.8/5
(37)
To add a title to a report in Report Layout view, you click the _____ button on the Design tab.
(Multiple Choice)
4.7/5
(38)
You use the Header button to add a title to a report in Report Design view.
(Short Answer)
4.7/5
(30)
What property should you set to have the Department header section appear at the top of every printed page?
A) Repeat
(Short Answer)
4.8/5
(36)
Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.
(Multiple Choice)
4.9/5
(44)
To resize a control in Report Layout view, you format an edge of the selected control.
(Short Answer)
4.7/5
(34)
Which report section is most commonly used for dates and page numbers?
(Multiple Choice)
4.9/5
(27)
Which of the following techniques can you use to select all the controls in Report Design view? Select all the options that apply.
(Multiple Choice)
4.8/5
(38)
In Report Layout view, you can work with sections and make changes that you cannot make in other views.
(Short Answer)
4.7/5
(38)
Which of the following techniques can you use to resize a selected control in Report Design view? Select all the options that apply.
(Multiple Choice)
4.8/5
(29)
Showing 21 - 40 of 43
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)