Formative Task 1 - Wages

task

Create the Simple Wages Spreadsheet shown at the bottom of this page. Save it into your Spreadsheets folder as Surname_FirstName_T1_Wages

i.e if your name was Minnie Mouse you would save the file as Mouse_Minnie_T1_Wages. (see below)

Note: Some of the video tutorials for this unit show an earlier version of Excel (which looks slightly different to the one you are using) but the instructions will work exactly the same on your version.

save

Resources

vid

Watch the attached First Spreadsheet Video Tutorial to help. (4 minutes)

yt

The cells in Row H use the Autosum formula. They add up all the data from Column C (Mon) to Column G (Fri). The formula you will need to use is shown below:

formula

spreadsheet