79. Excel 2016 makes recommendations for using specific chart types based on the

Question

79. Excel 2016 makes recommendations for using specific chart types based on the you have selected in the worksheet A. labels B. data C. styles D. formatting function lets you enter a desired value (outcome) for 80. Excel's a formula and specify an input cell that can be modified in order to reach that goal. A. Consolidate B. Goal Seek c. Filter D. Input 81. If your data are formatted as a table, automatically. A. filtering B. sorting c. formatting D. converting is enabled 82. In a chart, the values selected in the worksheet, the data points, are transformed into graphic A. data labels B. data markers C. data columns D. data values 83. In a(n) the whole. A. whole B. exploded C. partial D. sliced " pie chart, each slice is slightly separated from 84. The Goal Seek feature can be found after clicking the A. Consolidate B. Data Validation c. What-If Analysis D. Group button. 85. A. t Thetype you select affects the story your chart tells. B. data C. chart D. worksheet 86. The chart provides a key so you know which data point or data series is represented by each color in the chart. A. legend B. data points c. categories D. slices

Explanation / Answer

79. B. DATA

80. B. GOAL SEEK

81. C. FORMATTING

82. A. DATA LABLE

83. D. SLICED

84. C. WHAT IF ANALYSIS

85. B. DATA

86. D. SLICES

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.