To find total sales for each city. To construct column chart for First Quarter and Fourth Quarter sales for all cities. To construct Pie chart of Total Sales. (Excel-2007)

The following data has been entered in a Excel worksheet:

Based on these values, write steps to

 (i) To find total sales for each city.

Enter the formula,

=SUM(B5:B8) in cell B9 and then press enter key,

using the fill handle of cell B9, copy the formula to cells C9 :E9, by dragging the fill handle up to cell E9.

(ii) To construct column chart for First Quarter and Fourth Quarter sales for all cities.

Select cells B4:E5 and keep the control key pressed and select cells B8:E8.

Now click on INSERT tab, in Insert tab click on column chart from CHART group, from sub chart select first sub chart

(iii) To construct Pie chart of Total Sales.

Select cells B4:E4,keep the control key pressed and now select cells B9: E9.

Click on INSERT tab, in Insert tab click on PIE from CHART group, from sub chart select FIRST chart.

Related Posts by Categories