nerdexam
Microsoft

77-427 · Question #19

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. The report worksheet will include the sales made by all the sales managers in the month of…

The correct answer is D. Pie. In order to accomplish the task, you will have to insert a pie chart in the worksheet. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet. Pie charts display the size of items in one data series, proportional to the sum of…

Create charts and objects

Question

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. The report worksheet will include the sales made by all the sales managers in the month of January. In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?

Options

  • ABar
  • BLine
  • CColumn
  • DPie

How the community answered

(67 responses)
  • A
    13% (9)
  • B
    4% (3)
  • C
    9% (6)
  • D
    73% (49)

Explanation

In order to accomplish the task, you will have to insert a pie chart in the worksheet. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet. Pie charts display the size of items in one data series, proportional to the sum of the items.

Topics

#pie chart#percentage visualization#sales data#chart selection

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice