Exam 6: Managing Data With Data Tools
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
In a calculated control, expressions must start with what character?
(Multiple Choice)
4.9/5
(29)
A(n) _____ is a common control to place within an option group.
(Multiple Choice)
4.8/5
(39)
Which control allows you to type an entry or choose an entry from a list?
(Multiple Choice)
4.8/5
(35)
One way to group objects in the Navigation Pane is by object type.
(True/False)
4.8/5
(39)
The Database Documenter provides step-by-step help for using an Access database.
(True/False)
4.8/5
(35)
What could you use to display the amount of a 25% discount on a form?
(Multiple Choice)
4.9/5
(32)
Which of the following options can you set for a text box in a control layout? Select all the options that apply.
(Multiple Choice)
4.9/5
(34)
Which of the following changes can you make to a form in Form Layout view? Select all the options that apply.
(Multiple Choice)
4.8/5
(34)
Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?
(Multiple Choice)
4.8/5
(33)
When you click the first value in a column in Report Layout view, what are you actually selecting?
(Multiple Choice)
4.9/5
(30)
To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.
(Multiple Choice)
4.8/5
(27)
Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.
(Multiple Choice)
5.0/5
(39)
In a multicolumn report, you can set the column layout as "Across, then Down" or as _____.
(Multiple Choice)
4.9/5
(33)
Which of the following formatting changes can you make to report control text in Report Layout view? Select all the options that apply.
(Multiple Choice)
4.9/5
(41)
To change the background color of a form control in Form Design view, you use the _____ button.
(Multiple Choice)
4.8/5
(30)
Which of the following layouts can you use to arrange form controls?
(Multiple Choice)
4.8/5
(30)
A report with _____ is a good candidate for a multicolumn report.
(Multiple Choice)
4.9/5
(32)
Which field property do you use to change a lookup field to a regular field?
(Multiple Choice)
4.8/5
(32)
A _____ allows you to work with records related to the record in the main form.
(Multiple Choice)
4.8/5
(36)
Clicking in the vertical ruler in Report Design view selects _____.
(Multiple Choice)
5.0/5
(32)
Showing 61 - 80 of 120
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)