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:

D, A, B, C

Correct answer: Option (2) → D, A, B, C

Concept: A chart in Excel is created by first entering the data, selecting it, then choosing the chart type and its sub-type from the ribbon – per Graphs and Charts for Business Data.

Correct sequence: (D) Enter the data in a worksheet → (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. Hence D, A, B, C.