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
Where do you specify the number of columns for a report?
Free
(Multiple Choice)
4.7/5
(31)
Correct Answer:
C
How can you enlarge the Detail section of a form in Form Design view?
Free
(Multiple Choice)
4.8/5
(31)
Correct Answer:
A
Which of the following form controls would you use to display a border around other controls?
Free
(Multiple Choice)
4.9/5
(32)
Correct Answer:
B
If you select a(n)_____ control on a form in Form view,it means "yes" or "true".
(Multiple Choice)
4.8/5
(38)
What could you use to display the amount of a 25% discount on a form?
(Multiple Choice)
4.8/5
(37)
To right-align the text in a text box,you use the Align Right button on the Home tab.
(True/False)
4.9/5
(26)
Which of the following changes can you make to a form in Form Layout view? Select all the options that apply.
(Multiple Choice)
4.7/5
(35)
Which of the following form controls can you format by applying a style to it?
(Multiple Choice)
4.8/5
(37)
You can modify the lookup settings for a field in Table Datasheet view.
(True/False)
4.7/5
(40)
In a calculated control,expressions must start with what character?
(Multiple Choice)
4.9/5
(43)
Which of the following is a valid entry for the Tab Stop property of a form control?
(Multiple Choice)
4.8/5
(36)
To select more than one control in Form Design view,you _____ and then click each control.
(Multiple Choice)
4.9/5
(40)
A check box control usually displays a "yes" or "no" answer for a field.
(True/False)
4.9/5
(43)
To change the text displayed on the report tab,you set the _____ property of the report.
(Multiple Choice)
5.0/5
(31)
When you use the Combo Box Wizard,you can have the combo box list the values from a table or query or you can _____.
(Multiple Choice)
4.8/5
(34)
The _____ determines the underlying table or query for a form.
(Multiple Choice)
4.8/5
(39)
In Table Datasheet view,you can press CTRL+A to select all the table's records.
(True/False)
4.8/5
(27)
Showing 1 - 20 of 118
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)