Question

Insert subtotals, using the Sum function, for each category in the State field, sorted A to Z in range A4:019. The subtotals should add the values in the Workshops Attended field for each State category, and then include a grand total. Calibri 11. Α' Α' 19 W Paste BIU. A. Mer Clipboard Font Alignment E1 А B С D 4 Last Name Long Handley 7 Riehle 8 Kawada 9 Robins TN 10 Nunn 11 Lopez 12 Wilcox 13 Allu First Name State Stephan GA Miriam TN Paul GA Carolyn GA Jayden LaShonda TN Marcella TN Evelynn GA Sari GA Danny Stan GA Ironca CA Workshop Participants Workshops

Answer 1

To insert subtotals using the Sum function for each category in the State field and have a grand total, follow these steps.

Step-by-step explanation:

To insert subtotals using the Sum function for each category in the State field, you can follow these steps:

1. Select the range A4:A19.
2. Go to the 'Data' tab and click on the 'Subtotal' button in the 'Outline' group.
3. In the 'Subtotal' dialog box, select 'State' as the 'At each change in' option.
4. Select 'Sum' as the function to use and choose the 'Workshops Attended' field to subtotal.
5. Make sure that 'Replace current subtotals' and 'Summary below data' options are selected.
6. Click on the 'OK' button.

This will insert subtotals for each category in the State field, sorted A to Z, and include a grand total in cell A19.

Answer 2

To insert subtotals in Excel, sort the data by state, use the 'Subtotal' button under the Data tab, apply the Sum function to the 'Workshops Attended' field, set the font to Calibri size 11, and finally, insert a grand total.

Step-by-step explanation:

To insert subtotals using the Sum function for each category in the State field in a range from A4 to O19, follow these steps:

1. First, ensure that your data is sorted by the State field in ascending order (A to Z).
2. Select the range of cells containing your data.
3. Go to the Data tab on the Excel ribbon and click on the 'Subtotal' button.
4. In the Subtotal dialog box, choose the State field to use for the 'At each change in' field.
5. Then, select 'Sum' as the function.
6. Check the box for 'Workshops Attended' to add subtotals for this field.
7. Click 'OK' to apply the subtotals.
8. To apply the font Calibri with the size of 11 to your subtotals, select the cells containing the subtotal data, then change the font settings accordingly.
9. Finally, insert a grand total at the bottom of the Workshops Attended column by using the Sum function across all the subtotals for the respective State categories.

Once these steps are completed, you will have subtotals for each State category, neatly organized and displayed in your spreadsheet. This process effectively summarizes your data and highlights the total Workshops Attended per state, plus a grand total.