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
To repeat an action in Design view or Layout view, use the _____ button.
(Multiple Choice)
4.9/5
(26)
Which of the following options for creating a form can you access on the Create tab? Select all the options that apply.
(Multiple Choice)
4.9/5
(39)
To run a macro from a form, add a check box control to the form.
(True/False)
4.8/5
(32)
The report source is the table or query that contains the fields and records displayed in the report.
(True/False)
4.8/5
(37)
To add a background image to a report in Report Layout view, you use the _____ button.
(Multiple Choice)
4.8/5
(38)
You can modify the lookup settings for a field in Table Datasheet view.
(True/False)
4.8/5
(37)
In Table Datasheet view, you can press CTRL+A to select all the table's records.
(True/False)
4.9/5
(28)
Which control works best to display three choices-1, 2, or 3-for a Rating field?
(Multiple Choice)
4.9/5
(36)
Use the Align button on the Arrange tab to align the edges of the controls.
(True/False)
4.8/5
(38)
How can you enlarge the Detail section of a form in Form Design view?
(Multiple Choice)
4.9/5
(41)
Which of the following controls would you use to display a Yes/No field on a form?
(Multiple Choice)
4.7/5
(39)
How do you select a row in a control layout in Report Layout view?
(Multiple Choice)
4.8/5
(29)
Which of the following commands can you use to add a picture to a form? Select all the options that apply.
(Multiple Choice)
4.7/5
(35)
How can you change the shape of a button from a rounded rectangle to an oval?
(Multiple Choice)
4.9/5
(35)
What are you changing when you change the background of a report label?
(Multiple Choice)
4.8/5
(36)
A form ____ is the general way that the data and controls are arranged on the form.
(Multiple Choice)
4.9/5
(27)
Which control do you use to add a report to another report?
(Multiple Choice)
4.7/5
(33)
Access creates fields with _____ properties as combo boxes on new forms.
(Multiple Choice)
4.9/5
(33)
Showing 21 - 40 of 120
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)