Exam 9: Formula Auditing, Data Validation, and Complex Problem Solving
Exam 1: Creating a Worksheet and a Chart66 Questions
Exam 2: Formulas, Functions, and Formatting68 Questions
Exam 3: Working With Large Worksheets, Charting, and What-If Analysis75 Questions
Exam 4: Financial Functions, Data Tables, and Amortization Schedules70 Questions
Exam 5: Working With Multiple Worksheets and Workbooks72 Questions
Exam 6: Creating, Sorting, and Querying a Table63 Questions
Exam 7: Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots64 Questions
Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers67 Questions
Exam 9: Formula Auditing, Data Validation, and Complex Problem Solving74 Questions
Exam 10: Data Analysis With Power Tools and Creating Macros68 Questions
Exam 11: User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel56 Questions
Select questions type
To ensure the lines within a paragraph are not separated on different pages,which of the following should be done?
(Multiple Choice)
4.8/5
(32)
To insert a list of figures in a document,which of the following should be done?
(Multiple Choice)
4.9/5
(45)
To create a section break and start the new section on the same page,insert an Even Page section break.
(True/False)
4.9/5
(32)
Amy is creating a document that will be bound as a book.To ensure text is not obscured by the binding,she should do which of the following?
(Multiple Choice)
4.8/5
(40)
Before distributing a document via email,make sure to do which of the following?
(Multiple Choice)
4.8/5
(35)
To change the alignment of page numbers in a table of contents,which of the following should be done?
(Multiple Choice)
4.9/5
(42)
To prevent edits to subdocuments in a master document,which of the following should be done?
(Multiple Choice)
4.9/5
(36)
To insert a section break that will start the new section on the next odd page of the document,which of the following should be done?
(Multiple Choice)
4.8/5
(40)
To ensure a table of contents is up-to-date,which of the following should be done?
(Multiple Choice)
4.8/5
(35)
Sharon needs to view a document as continuous text with page breaks denoted by dotted lines.She should do which of the following?
(Multiple Choice)
4.8/5
(33)
In order to include a citation in a table of authorities,which of the following should be done?
(Multiple Choice)
4.8/5
(33)
To use the same footer for two adjacent sections,which of the following should be done?
(Multiple Choice)
4.8/5
(35)
To add a subdocument to a master document,which of the following should be done? Select all that apply.
(Multiple Choice)
4.8/5
(30)
To add a predesigned page at the beginning of a document,insert a cover page.
(True/False)
4.8/5
(33)
To add headings to a document while in Outline view,which of the following should be done?
(Multiple Choice)
4.8/5
(29)
To allow users to click text and immediately move to a location in the document,which of the following should be done?
(Multiple Choice)
5.0/5
(22)
To only see the highest level headings in a document,select Level 9 in the Show Level drop down box.
(True/False)
4.8/5
(37)
Katie noticed that a table of figures in her document is missing a reference to one of the images.She should do which of the following?
(Multiple Choice)
4.8/5
(35)
To create a different footer for the first page of a document,which of the following should be done?
(Multiple Choice)
4.8/5
(39)
Showing 21 - 40 of 74
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)