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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
