To display the Total units sold with a condition as shown on the figure below for cell B15, the function will be used. BIS (62811 ASCII) A GO D MONTH SALES PERSON UNIT SOLD Satish Ethan Zulkarnain 135 230 221 108 2 JANUARY 3 JANUARY 4 JANUARY SANUARY JANUR FEBRUARY FEBRUARY FEBRUAR FEBRUARY 150 Balqish St Baloish 113 14 Sales person Baiqish Total unit wala 490 O A COUNTIF B. TOTAL C. SUM D. SUMIE Question 3 Not yet Sakinah has created a bar chart on Excel for the data analysis. But she was asked to use a column chart to represent the data. How can she change a complete Bar Chart to a Column Chart? answered Marked out of 100 O A. None of the options listed above are correct. P Flag question O B. Right-click the Bar Chart and select rotate from the menu list. This will turn the bar chart vertically to display as columns. O C. Select the chart, click on the Design tab, and then select the Switch Row/column button to rotate the data so that it displays as columns O D. Select the chart, click on the Design tab, and then select the Change Chart Type button and select the Column Chart from the list. Previous page Next page