Again refer to the screenshot below. Suppose we want to use the Subtotal feature
ID: 2739632 • Letter: A
Question
Again refer to the screenshot below. Suppose we want to use the Subtotal feature to create a summary of our sales data that lists the total units sold by each salesperson in January, followed by the total units sold by each salesperson in February, etc. What sort order should be implemented before running the subtotals?
A. Sort by Month
B. Sort by Name
C. Sort by Units Sold
D. Sort by Name, then Month
E. Sort by Month, then Name
F. Sort by Units Sold, then Month
1Name Month Units Sold Jake May Jake Feb Erik JakeJan 6 Bruce June Bruce March JohnJune Alex April John May 14) 13 John March 4 John March 15 John Mach Feb 7AlexFeb 9Allan March Allan eb Bruce Feb Alex June il1Api Allanan 5 ohn March 118 136 UricExplanation / Answer
Solution: We will first sort by month and then by name of salesperson Here we will start with sorting monthly sale followed by sorting by no of unit sold by each sale person in particular month. So answer is OPTION E Alternate; We will first sort by total sale in year then in month and then by name of salesperson similar to option e