7. Open the Food 2 worksheet. 8. In the Food 2 worksheet, sort the data in ascending order by Type and then by Zip. 9. Using conditional formatting, highlight all of the records in the sorted table that are the type Food with the format of Green Fill with Dark Green Text. 10. Samuel is trying to include subtotals that show the total value for each donation Type. Use the subtotal command to determine the total value of donations for each type. 11. Apply a second subtotal to provide a count of the number of donations by Zip. 12. Save your workbook. 7. Open the Food 2 worksheet. 8. In the Food 2 worksheet, sort the data in ascending order by Type and then by Zip. 9. Using conditional formatting, highlight all of the records in the sorted table that are the type Food with the format of Green Fill with Dark Green Text. 10. Samuel is trying to include subtotals that show the total value for each donation Type. Use the subtotal command to determine the total value of donations for each type. 11. Apply a second subtotal to provide a count of the number of donations by Zip. 12. Save your workbook