You want to find out the year wise total sales on different regions.
You want to find out the year wise total sales on different regions. Which of the following should you perform in MSExcel 2010 to achieve the same?
A
Sort the Year field from smallest to largest. Then, select the Data tab and click the Subtotal command to use it.
B
Sort the State field in ascending order. Then, select the Data tab and use the Group command to use it.
C
Sort the Year field from smallest to largest. Then, select the Data tab and clickthe Consolidate command to use it.
DSort the State field in ascending order. Then, select the Data tab and click the Subtotal command to use it.
Post your answers here:
Post
