Exam 6: Managing Data With Data Tools
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
Use the Align button on the Arrange tab to align the edges of the controls.
(True/False)
4.7/5
(32)
If the focus in a form moves from left to right and you want the focus to move from top to bottom,change the _____.
(Multiple Choice)
4.9/5
(43)
If you delete the text box for the State field on a report,Access removes _____.
(Multiple Choice)
4.8/5
(35)
A(n)_____ is a common control to place within an option group.
(Multiple Choice)
4.8/5
(35)
To change the column layout in a report in Report Design view,you use the _____.
(Multiple Choice)
4.8/5
(30)
Which control would you add to a report to allow users to enter or select an option from a list?
(Multiple Choice)
4.9/5
(37)
Which of the following controls would you use to display a Yes/No field on a form?
(Multiple Choice)
4.9/5
(29)
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.8/5
(36)
Clicking in the vertical ruler in Report Design view selects _____.
(Multiple Choice)
4.8/5
(37)
Access creates fields with _____ properties as combo boxes on new forms.
(Multiple Choice)
4.8/5
(39)
What criterion would you use in the LastName field to find records that do not contain a last name?
(Multiple Choice)
4.8/5
(41)
Which of the following are actions you can set for a command button when you use the Command Button Wizard? Select all the options that apply.
(Multiple Choice)
4.8/5
(27)
If you change data in its original location and it is linked to an Access database,you must also update the data in the Access database.
(True/False)
4.9/5
(41)
Which of the following layouts can you use to arrange form controls?
(Multiple Choice)
4.8/5
(30)
To reverse the last action you took in a database,click the _____ button.
(Multiple Choice)
4.8/5
(34)
You can insert a logo in the form header using the ____ button on the Form Design Tools tab.
(Multiple Choice)
4.8/5
(29)
To add a background image to a report in Report Layout view,you use the _____ button.
(Multiple Choice)
4.9/5
(29)
In Report Design view,you can remove a control from a control layout by selecting the control and then _____.
(Multiple Choice)
4.9/5
(37)
If you _____ in the Form Wizard,you can create a form with a subform.
(Multiple Choice)
4.8/5
(37)
Showing 61 - 80 of 118
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)