$1$

COS$103$ Lab #$1$

Worth: $30$ points

Open Excel and use File $/$ New to create a workbook file named Lab$1.$ Insert data as shown using your

name in cell A$2.$ Widen columns as needed so all data displays.

Formulas: Write the formula once and copy it down remaining rows as needed making proper use of

relative versus absolute cell addresses. Do not use literal values for rates in formulas but refer to hourly

rates stored in B$10$:B$11.$