Exam 4: Analyzing and Charting Financial Data
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 features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.
Free
(Multiple Choice)
4.8/5
(37)
Correct Answer:
A,B,C
To create a report in Report Layout view,click the Blank Report button on the Create tab.
Free
(True/False)
4.7/5
(30)
Correct Answer:
True
Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?
Free
(Multiple Choice)
4.9/5
(33)
Correct Answer:
C
Which of the following options can you set when creating a report with the Report Wizard?
(Multiple Choice)
4.7/5
(32)
You use conditional formatting to highlight important data in a report.
(True/False)
5.0/5
(43)
Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.
(Multiple Choice)
4.7/5
(37)
Before closing a form in Form view,you must save changes you made to the data.
(True/False)
4.8/5
(34)
The two types of control layouts Access provides for forms are stacked and _____.
(Multiple Choice)
4.9/5
(27)
The _____ button creates a new,blank report in Report Design view.
(Multiple Choice)
4.9/5
(32)
Compared to forms and datasheets,____ give you more control over how data is arranged when printed.
(Multiple Choice)
4.9/5
(30)
In Report Layout view,you use the Format Painter to change the theme of a report.
(True/False)
4.9/5
(34)
Which of the following are form views? Select all the options that apply.
(Multiple Choice)
4.8/5
(29)
What happens in a table if you change the font color of the primary key field for the first record to red?
(Multiple Choice)
4.9/5
(32)
A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.
(True/False)
4.9/5
(31)
Conditional formatting can change the appearance of a report control based on criteria you specify.
(True/False)
4.8/5
(32)
Which of the following formatting enhancements do themes apply to reports? Select all the options that apply.
(Multiple Choice)
4.9/5
(36)
What information does the Form Wizard request as it creates a form? Select all the options that apply.
(Multiple Choice)
4.9/5
(33)
Showing 1 - 20 of 37
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)