Produce+Spreadsheets+-+BSBITU304A

=BSBITU304A - Produce Spreadsheets=

Student Assessment Guide Unit Guide

** 1.1 Unit Purpose **
On successful completion of this unit you should be able to develop spreadsheets through the use of spreadsheet software. Specifically you will: · select and prepare resources · plan spreadsheet design · create spreadsheet · produce simple charts · finalise spreadsheets

** 1.2 Grading **
Ungraded
 * Grade Code: || 42 : Competency (Ungraded) ||  ||

__Exercise 1__ __Exercise 2 __

__Exercise 3__ Rename Sheet 3, from exercise 1, to "Bank".

Use Figure 1 below to design this new sheet. The Sheet Bank will be used to assist in the accurate counting and preparation of bank deposits for the organisation.

Figure 1:
//Sheet Bank//



__Exercise 4__ Reproduce the worksheet. You will need to add formulas and format appropriately.

__Exercise 5__ Reproduce the worksheet. You will need to add formulas and format appropriately.