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
You use the _____ control when you want to link two reports together in the same report.
(Multiple Choice)
4.8/5
(26)
In which one of the following views can you edit the text in a label?
(Multiple Choice)
4.7/5
(35)
In Report Design view, you can remove a control from a control layout by selecting the control and then _____.
(Multiple Choice)
4.7/5
(34)
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.9/5
(34)
What do you change when you drag the right border of a form in Form Design view?
(Multiple Choice)
4.8/5
(19)
When you add a new field to a form, two controls are usually created: a(n) caption and a text box.
(Short Answer)
4.8/5
(34)
Which of the following form controls would you use to display a border around other controls?
(Multiple Choice)
4.8/5
(30)
To quickly remove all Lookup properties from a field, change the Display Control property to _____.
(Multiple Choice)
4.8/5
(45)
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.8/5
(33)
Which of the following form controls can you format by applying a style to it?
(Multiple Choice)
4.9/5
(40)
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
(35)
To resize a control in Report Design view, you select the control and then _____.
(Multiple Choice)
4.9/5
(32)
A command button in a report typically appears in the _____ section.
(Multiple Choice)
5.0/5
(32)
You can select one or more option buttons at the same time within an option group.
(True/False)
4.9/5
(32)
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.8/5
(37)
A form control with its Focus Stop property set to Yes will receive the focus in Form view.
(Short Answer)
4.8/5
(41)
To set a command button to be a hyperlink in Form Design view, you change the button's _____ property.
(Multiple Choice)
4.9/5
(34)
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.9/5
(31)
Showing 81 - 100 of 120
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)