Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers
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
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.8/5
(40)
To insert a preformatted table template in a document,Insert a Quick Table.
(True/False)
4.8/5
(31)
To keep a record of changes made to a document,enable the Word Count option.
(True/False)
4.8/5
(36)
Jane needs to recolor a line in a Line chart.She should do which of the following?
(Multiple Choice)
4.8/5
(30)
To create a copy of a chart in a document,use the Cut and Paste commands.
(True/False)
4.8/5
(43)
To add numerical information about data in a chart,which of the following should be done?
(Multiple Choice)
4.9/5
(44)
Jasmine wants a line to appear around a chart,she should do which of the following?
(Multiple Choice)
4.7/5
(36)
To add information about the horizontal and vertical extent of a chart,which of the following should be done?
(Multiple Choice)
4.9/5
(35)
To add a data point to an X Y Scatter chart,which of the following should be done? Change the chart style.
(Multiple Choice)
5.0/5
(36)
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.9/5
(33)
Karen needs to change the name that appears when she adds comments to a document.She should do which of the following?
(Multiple Choice)
4.9/5
(32)
Aaron needs to copy a chart from an Excel file and paste it into a Word document.He wants the chart to retain its original formatting.He should select which of the following paste options?
(Multiple Choice)
4.9/5
(35)
Jane received a document that has tracked changes.To view the insertions and deletions,she should do which of the following?
(Multiple Choice)
4.8/5
(43)
To quickly change the appearance of a chart,change the chart style.
(True/False)
4.8/5
(34)
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
(25)
To update an Excel chart inserted into a Word document,which of the following should be done?
(Multiple Choice)
4.8/5
(40)
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
(30)
Amy needs to create a copy of a chart in a document.She should do which of the following? Select all that apply.
(Multiple Choice)
4.8/5
(29)
Showing 41 - 60 of 67
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)