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 display a document as continuous text and page breaks denoted by dotted lines,switch to Draft view.
Free
(True/False)
4.7/5
(41)
Correct Answer:
True
Collapsing a subdocument does which of the following?
Free
(Multiple Choice)
4.7/5
(33)
Correct Answer:
A
To reduce the size of a document,which of the following should be done?
Free
(Multiple Choice)
4.8/5
(35)
Correct Answer:
C
Aaron is working on a document in Outline view.He needs to view text formatting,but all the text in the document appears without formatting.He should do which of the following?
(Multiple Choice)
4.9/5
(39)
To reduce the size of a document,you can compress the pictures in the document.
(True/False)
4.8/5
(31)
To move a heading to a lower level,which of the following should be done? Select all that apply.
(Multiple Choice)
4.7/5
(37)
Jasmine wants a term in an index to appear subordinate to another term in the index.She should do which of the following?
(Multiple Choice)
4.8/5
(37)
To display an equation in a document,which of the following should be done?
(Multiple Choice)
4.9/5
(29)
To include a subdocument's text directly within the master document,which of the following should be done?
(Multiple Choice)
4.9/5
(38)
To show the subdocuments in a master document,which of the following should be done?
(Multiple Choice)
4.9/5
(31)
Kendra is working on a document in Outline view.She only wants to see the first line of each paragraph in the document.She should do which of the following?
(Multiple Choice)
4.9/5
(32)
Place the cursor on the desired heading and then click the plus symbol in the Outlining tab to expand the heading.
(True/False)
5.0/5
(28)
To insert a screenshot in a document,which of the following should be done?
(Multiple Choice)
4.9/5
(36)
To enable people to immediately scroll to a bookmark by clicking text in a document,which of the following should be done?
(Multiple Choice)
4.9/5
(28)
To ensure a document index is up-to-date,which of the following should be done?
(Multiple Choice)
4.9/5
(34)
To have a different header for different sections in a document,which of the following should be done?
(Multiple Choice)
4.9/5
(37)
Word allows you to specify the distance of a footer from the edge of a page.
(True/False)
4.8/5
(31)
To create a section break and start the new section on the next odd-numbered page,insert an Odd Page section break.
(True/False)
4.7/5
(43)
Showing 1 - 20 of 74
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)