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.

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.

[order_button_a]

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

[order_button_b]