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
You use conditional formatting to highlight important data in a report.
(True/False)
4.9/5
(75)
Which Access tool guides you through the steps of creating a report?
(Multiple Choice)
4.8/5
(80)
When you create a report using the _____, Access includes all the fields in the selected table.
(Multiple Choice)
4.9/5
(75)
Before closing a form in Form view, you must save changes you made to the data.
(True/False)
4.9/5
(80)
To create a report in Report Layout view, click the Blank Report button on the Create tab.
(True/False)
4.8/5
(84)
A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.
(True/False)
4.7/5
(81)
Which of the following are form views? Select all the options that apply.
(Multiple Choice)
4.8/5
(87)
After changing the _____ of a report control, you might also need to widen the control.
(Multiple Choice)
4.8/5
(76)
Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.
(Multiple Choice)
4.9/5
(84)
How can you highlight report records that include values greater than $500 in the OrderAmt field?
(Multiple Choice)
4.8/5
(90)
Compared to forms and datasheets, ____ give you more control over how data is arranged when printed.
(Multiple Choice)
4.9/5
(80)
In Form Design view, you can make design changes while displaying the data.
(Short Answer)
4.8/5
(94)
In a form, how you can highlight the CustomerType text box only when it contains the value New?
(Multiple Choice)
4.8/5
(67)
When using the Form Wizard, you can select fields from tables and _____ in the database.
(Multiple Choice)
4.8/5
(83)
To change the color of the labels in a report, select the label controls, and then click the Background Color button.
(Short Answer)
5.0/5
(79)
In Report Design view, you remove a control layout from a report using the Control Padding button.
(True/False)
4.9/5
(67)
In Form view, how can you navigate to the previous record in the form?
(Multiple Choice)
4.8/5
(77)
Showing 21 - 40 of 41
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)