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:
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.
Related questions:
2023: 28 May Shift 1
2026: 11 May Shift 1
2022: 16 July Shift 2
2026: 21 May Shift 2