Question: On the Animals worksheet, sort the table alphabetically by Class, then by Animal. On the Exhibits worksheet, use a formula to fill in the Abbr.

  • On the Animals worksheet, sort the table alphabetically by Class, then by Animal.
  • On the Exhibits worksheet, use a formula to fill in the Abbr. column with the first letter of the Location on the same row (e.g. South is abbreviated as S).
  • On the Exhibits worksheet, in the Open column, use a formula to write No for all exhibits in the South location and Yes for all other exhibits.
  • On the Class Breakdown worksheet, add Center Data Labels to the chart.
  • On the Ticket Prices worksheet, use an Excel feature to remove all formatting from B2:C5. Don't

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!