You work as a staff and pharmacy administrator for a hospital. You're making an Excel workbook to keep track of employee and pharmaceutical information. Perform the following tasks:

On the Medicine worksheet, add a new row to the table that automatically shows the total number of bottles in stock. Use a technique that automatically adds the row to the bottom of the table and makes the calculation in one step.

On the Medicine worksheet, name the table Medicines.

On the Medicine worksheet, make the table show only medicines that have at least $100$ bottles in stock.

On the Doctors worksheet, sort the table by Specialty, then sort each specialty by Clinic.

Change the orientation of the Doctors worksheet so it prints with the long edge of the paper at the top.