Lab 1 Exercise

Lab 1 Exercise

 * Open a new MS Excel Workbook.
 * Type in 2 Column headings: Month and Sales Amount.
 * Fill in the Month column with the months January - December (hint: Use Autofill).
 * Fill in the Sales Amount column with multiples of 5, starting at 5, i.e. 5, 10, 15, 20, ..etc (hint: Use Autofill).
 * Format the numbers entered so they appear with Dollar signs, and show 3 decimal points.
 * Calculate the Sales Amount average, standard deviation, maximum, minimum and mode.

After I see your work, you are free to leave :)
 * EXTRA: Use conditional formatting to highlight values above 20.