Rename the Sheet 1 tab at the bottom of the worksheet to ‘Data’.
Title columns A-C: Name, Date, and Amount.
In column A, list the last names of 8 fictional patients.
In column B, enter a random date for each patient.
In column C, enter a random amount of medication for each patient. Enter random numbers only. Do not include the unit of measurement (ml., mg., etc.) – enter numbers only.
Alphabetize the patient’s last names in A-Z sort order.
Insert a new column between columns A and B. Title this column first name and populate the column with first names. Insert a new row within the middle of your list.
Populate it with patient name John Doe.
Apply center alignment on all cells with data in them.
Use the Border tool to create definition around a cell within your sheet.
Choose a Fill color for your column titles.
Autofit the width and height of all cells with data in them so all data is clearly visible.
Highlight cells D2:D10 to place the SUM function in cell D11 (see SUM tutorial video for reference)Links to an external site..
Highlight cells D2:D10 to place the AVERAGE function in cell D12 (see
AVERAGE tutorial video for reference)Links to an external site..
Highlight cells D2:D10 to place a 3rd function from the autosum menu in cell D13.
Highlight cells A1:D10. Click on Insert Tab. Select a chart format for this data
