Tomoko has created a table for the sale of sweatshirts in her shop last month with the headings,Customer's Name,Sweatshirt Size,Order ID and Payment Date.She wants to sort the number of sweatshirts of each size -Small,Medium,Large and Extra Large,bought by different customers.To do so,she can first sort her worksheet by sweatshirt size from smallest to largest,then click Subtotal command under the Data tab.Tomoko can then click the drop-down arrow for the At each change in field and select 'Sweatshirt Size',then select COUNT to count the number of sweatshirts ordered in each size.Then she can select 'Sweatshirt Size' in the Add subtotal to field and finally click OK.
Correct Answer:
Verified
Q2: Kylie is a corporate trainer. She creates
Q3: To ungroup a range of cells in
Q4: Soledad wants to create an auto outline
Q5: Cedric has a list of data that
Q6: Haley wants to delete a column in
Q8: To collapse data views using the Outline
Q9: To group specific rows in Excel,select them,then
Q10: Kathy wants to rename a table she
Q11: Shelley creates a table containing the marks
Q12: Which dialog box opens after selecting a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents