Exam 7: Summarizing Data With Pivottables
Exam 1: Getting Started With Excel85 Questions
Exam 2: Formatting Workbook Text and Data52 Questions
Exam 3: Performing Calculations With Formulas and Functions60 Questions
Exam 4: Analyzing and Charting Financial Data37 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks65 Questions
Exam 6: Managing Data With Data Tools118 Questions
Exam 7: Summarizing Data With Pivottables40 Questions
Exam 8: Performing What-If Analyses56 Questions
Exam 9: Exploring Financial Tools and Functions56 Questions
Exam 10: Analyzing Data With Business Intelligence Tools60 Questions
Exam 11: Exploring Pivottable Design78 Questions
Exam 12: Developing an Excel Application94 Questions
Select questions type
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.9/5
(34)
To add totals to a report column in Report Design view,you create a calculated control.
(True/False)
4.9/5
(29)
In Report Design view,you add a field to a report using the _____.
(Multiple Choice)
5.0/5
(32)
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.9/5
(26)
To add a title to a report in Report Layout view,you click the _____ button on the Design tab.
(Multiple Choice)
4.9/5
(30)
To create a report based on an existing report named Clients,you can _____.
(Multiple Choice)
4.8/5
(31)
Changing the title of a report in Report Layout view also changes the name of the report.
(True/False)
4.8/5
(35)
To add a sort to a report in Report Design view,you use the _____ button.
(Multiple Choice)
4.7/5
(34)
Which of the following report controls can you format in bold?
(Multiple Choice)
4.8/5
(31)
When you select a control in Form Design view,you can use _____ to resize the control.
(Multiple Choice)
4.8/5
(39)
After creating a report with the Report Wizard,you cannot add a sort to the report.
(True/False)
4.9/5
(39)
Which of the following are formatting properties you can apply to many report controls?
(Multiple Choice)
5.0/5
(44)
Which of the following actions selects all the report controls in Report Design view?
(Multiple Choice)
4.8/5
(46)
To select a control layout in Form Design view,you _____,and then click the plus sign icon to the left of the layout.
(Multiple Choice)
4.8/5
(33)
To add a field to a report in Report Design view,you use the report's property sheet.
(True/False)
4.8/5
(33)
When you delete a control from a form,you also delete the data it contains.
(True/False)
4.8/5
(40)
Showing 21 - 40 of 40
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)