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 control do you use to add a report to another report?
(Multiple Choice)
4.9/5
(33)
_____ means to connect data in an external file to an Access database.
(Multiple Choice)
4.8/5
(29)
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
(38)
To resize a control in Report Design view,you select the control and then _____.
(Multiple Choice)
4.7/5
(40)
How do you select a row in a control layout in Report Layout view?
(Multiple Choice)
4.8/5
(33)
Which field property do you use to change a lookup field to a regular field?
(Multiple Choice)
5.0/5
(31)
Why would you use Expression Builder to set a calculated field's property in Table Design view?
(Multiple Choice)
4.8/5
(32)
A(n)_____ is an image that fills the entire form,appearing "behind" the other controls.
(Multiple Choice)
4.8/5
(35)
The Database Documenter provides step-by-step help for using an Access database.
(True/False)
4.9/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
(32)
To have form users select one of three options,add a(n)_____ to the form.
(Multiple Choice)
4.9/5
(36)
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.8/5
(41)
To arrange form controls in a layout of rows and columns like a spreadsheet,select the controls to group together,and then click the _____ button on the Form Layout Tools Arrange tab.
(Multiple Choice)
4.7/5
(32)
In Form Layout view,you can edit the text in a _____ without changing any data.
(Multiple Choice)
4.8/5
(37)
Which of the following controls can you add to a form to clarify or organize form data? Select all the options that apply.
(Multiple Choice)
4.8/5
(33)
You use the _____ control when you want to link two reports together in the same report.
(Multiple Choice)
4.8/5
(27)
What are you changing when you change the background of a report label?
(Multiple Choice)
4.8/5
(34)
Showing 21 - 40 of 118
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)