Exam 7: Summarizing Data With Pivottables
Exam 1: Getting Started With Excel99 Questions
Exam 2: Formatting Workbook Text and Data66 Questions
Exam 3: Performing Calculations With Formulas and Functions84 Questions
Exam 4: Analyzing and Charting Financial Data118 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks52 Questions
Exam 6: Managing Data With Data Tools64 Questions
Exam 7: Summarizing Data With Pivottables103 Questions
Exam 8: Performing What-If Analyses45 Questions
Exam 9: Exploring Financial Tools and Functions89 Questions
Exam 10: Analyzing Data With Business Intelligence Tools94 Questions
Select questions type
Opal needs to add a chart element that describes each of the parts that help make up a chart. She should do which of the following?
(Multiple Choice)
4.7/5
(39)
Karen is working on a document with track changes. She wants to view a list of comments and formatting changes alongside the page, and she wants revisions to be displayed inline. She should select which of the following options?
(Multiple Choice)
4.7/5
(34)
To update an Excel chart inserted into a Word document, which of the following should be done?
(Multiple Choice)
4.9/5
(34)
The Combine command is used to combine the changes and comments of multiple reviewers into a single document when each reviewer edits the document using a separate copy of the original.
(True/False)
4.9/5
(34)
The most efficient way to share a Word document with collaborators is to save the document to a portable hard drive for distribution.
(True/False)
4.7/5
(36)
Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options?
(Multiple Choice)
4.8/5
(40)
John is working on a document with tracked changes. To move the insertion point to the previous tracked change in the document, he should do which of the following?
(Multiple Choice)
4.8/5
(27)
Kim has an Excel worksheet that she would like to display in a Word document. She should do which of the following?
(Multiple Choice)
4.8/5
(35)
Karen is working on a document with tracked changes. When she clicks Next in the Changes group of the Review tab, which of the following is true?
(Multiple Choice)
4.9/5
(36)
To change the color scheme of a chart, select the chart and click Change Colors.
(True/False)
4.7/5
(35)
Joan has a redundant source in her bibliography. What is the best way for her to remove this redundant source from the bibliography?
(Multiple Choice)
4.9/5
(41)
Karen needs to remove all changes applied to a document with track changes. She should do which of the following?
(Multiple Choice)
5.0/5
(37)
To email a document to clients who may or may not have Microsoft Office installed, which of the following should be done?
(Multiple Choice)
4.7/5
(33)
To quickly change the appearance of a chart without changing the way information is represented, which of the following should be done?
(Multiple Choice)
4.9/5
(39)
Caitlin wants her document to have a yellow background. She should do which of the following?
(Multiple Choice)
4.8/5
(32)
Aaron needs to see the tracked changes from Katherine, one of his editors. The file has been modified by multiple people. He should do which of the following?
(Multiple Choice)
4.8/5
(47)
Jasmine is creating a webpage in Word. She should save her document using which of the following extensions?
(Multiple Choice)
4.7/5
(42)
To publish a Word document as a webpage, save the document in which of the following formats?
(Multiple Choice)
4.8/5
(38)
Justin needs to efficiently share a Word document with collaborators. He should do which of the following?
(Multiple Choice)
4.8/5
(30)
Jasmine wants a line to appear around a chart, she should do which of the following?
(Multiple Choice)
4.9/5
(38)
Showing 41 - 60 of 103
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)