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
Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.
(Multiple Choice)
4.8/5
(34)
To run a macro from a form,add a check box control to the form.
(True/False)
5.0/5
(38)
In _____ view,you can make some design changes to a report while you are displaying the data.
(Multiple Choice)
4.9/5
(41)
If a form displays data from the Clients table,you could change the form's Record Source property to _____ to display different data.
(Multiple Choice)
4.7/5
(22)
The upper pane of a _____ displays the fields of one record,and the lower pane shows a datasheet view of the first few records.
(Multiple Choice)
4.9/5
(37)
On a form,text box controls display data from an underlying record source.
(True/False)
4.8/5
(28)
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
(27)
You can add a command button to a form using the Command Button Wizard,one of many _____ Wizards Access offers.
(Multiple Choice)
4.8/5
(39)
To change the background color of a form control in Form Design view,you use the _____ button.
(Multiple Choice)
4.9/5
(38)
To quickly remove all Lookup properties from a field,change the Display Control property to _____.
(Multiple Choice)
5.0/5
(33)
How can you change the shape of a button from a rounded rectangle to an oval?
(Multiple Choice)
4.8/5
(36)
To resize the form header in Form Layout view,you use the _____ property.
(Multiple Choice)
4.9/5
(42)
If you set the Visible property of a form's label control to Yes,the label does not appear in Form view.
(True/False)
4.7/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
(31)
A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find,enter,edit,and analyze data.
(Multiple Choice)
4.9/5
(37)
Showing 101 - 118 of 118
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)