Exam 4: Analyzing and Charting Financial Data
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
How can you display the title of a report in green?
Free
(Multiple Choice)
4.9/5
(38)
Correct Answer:
C
The two types of control layouts Access provides for forms are stacked and _____.
Free
(Multiple Choice)
4.8/5
(35)
Correct Answer:
B
You switch to Report Layout view to display the entire report as it will appear when printed.
Free
(True/False)
4.9/5
(32)
Correct Answer:
False
In Report Layout view, you use the Format Painter to change the theme of a report.
(True/False)
4.8/5
(30)
When you click the Blank Report button on the Create tab, Access opens a blank report in _____.
(Multiple Choice)
4.8/5
(28)
The _____ button creates a new, blank report in Report Design view.
(Multiple Choice)
4.9/5
(38)
Alternate colors are a set of coordinated colors to apply to reports and other database objects.
(Short Answer)
4.8/5
(43)
Conditional formatting can change the appearance of a report control based on criteria you specify.
(True/False)
4.9/5
(24)
Which of the following features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.
(Multiple Choice)
4.8/5
(27)
What happens in a table if you change the font color of the primary key field for the first record to red?
(Multiple Choice)
4.7/5
(37)
To close a form in Form Design view and keep Access running, you _____.
(Multiple Choice)
4.7/5
(42)
Which of the following options can you set when creating a report with the Report Wizard?
(Multiple Choice)
4.7/5
(37)
Which of the following formatting enhancements do themes apply to reports? Select all the options that apply.
(Multiple Choice)
4.8/5
(29)
When you remove a control layout from a report, Access ____
(Multiple Choice)
4.8/5
(41)
As you create a report, when might you want to work in Report Layout view?
(Multiple Choice)
4.8/5
(21)
Using the Report Wizard, you can select the _____ for the report.
(Multiple Choice)
4.7/5
(26)
Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?
(Multiple Choice)
4.8/5
(36)
What information does the Form Wizard request as it creates a form? Select all the options that apply.
(Multiple Choice)
4.9/5
(37)
Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?
(Multiple Choice)
4.8/5
(29)
Showing 1 - 20 of 41
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)