Skip to main contentSkip to solution

Arrange the following steps in order to create a pie chart in Excel

A. Select the data from two (consecutive) columns only.

B. Select the chart type Pie from the ribbon

C. Under Pie types, select one of the pie chart options.

D. Enter the data in a worksheet.

Choose the correct answer from the options given below:

Solution

✅ Correct Option: 2

Data must first exist in the worksheet, then the relevant two columns are selected, after which the Pie chart type is chosen from the Insert ribbon and finally a specific pie sub-type is picked.

Order: D, A, B, C.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question