Arrange the following steps in order to create a Pie Chart.
(A) Select the chart type Pie from the ribbon.
(B) Under Pie types, select the 3-D Pie option
(C) Enter the data in a worksheet.
(D) Select the data from two (consecutive) columns only.
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → (C), (D), (A), (B)
Each step needs the one before it, so the order follows what Excel must have in hand at every stage.
(C) first: there is nothing to chart until the data are in a worksheet.
(D) next: a pie chart shows the parts of one whole, so only two consecutive columns are selected, the labels and their values.
(A) then: with the data selected, the Pie chart type is chosen from the ribbon.
(B) last: the 3-D Pie is a sub-type offered only after the Pie type has been opened.
NCERT (2026-27 edition):
|
