Computing units

Operate a spreadsheet application CAITU130A

Spreadsheet Assignment Semester One 2007

Developed a spreadsheet using MS Excel to be used as a record sheet for use calculating results for a microbiological examination of food.

1) Use the example that can be downloaded here.

2) Into the appropriate cells Inset formulae to calculate the means and weighted mean.

3) Validate each cell used for data entry and set appropriate limits and type of data that can be entered using the Validate function in the Date dropdown menu

4) set error messages advising people of the type of data to be entered using the Validate function in the Date dropdown menu

5)Unlock the data cells on the spreadsheet using Protection function but allow access to the data cells using the Protection function in the Format > Cells Menu

6) Secure the spreadsheet using the Protection function in Tools dropdown menu.

6) to find out how to do steps 1 to 5 use the MS Excel help facility.