Certificate III in Accounts Administration – Accounting Assignment Help

Assignment Task

Task 1: Software Help

1. Open your spreadsheet software, such as Microsoft Excel.
2. Access the help feature of your software.
3. Search wrap text and open the result with instructions on how to Wrap text in a cell.
4. Screen shot or use the snipping tool to take a picture of your findings.
5. Print a copy of this picture. You may need to paste the picture into MS Word to print.

Task 2: Plan and Design a Spreadsheet
Create a spreadsheet to record the monthly sales for the March Quarter AND calculate the monthly, employee and quarter totals. Use your spreadsheet knowledge to plan, design and create the spreadsheet.
1. The following sales data is to be recorded:

• Edward Williams Nadia Woodward Katherine Cloak Jonathon Roundtree
• Sales for March Qrt
• January $5,400
• February $6,325
• March $8,700
• Sales for March Qrt January $9,500 February $7,650 March $8,560 Sales for March Qrt January $7,890 February $6,750 March $9,650 Sales for March Qrt January $4,870 February $10,560 March $7,700
• HINT: The layout of the data above is not an appropriate layout for your spreadsheet. We are assessing that you can design an appropriate spreadsheet for this task.

2. Include efficient formula to calculate:

a. Totals for each month
b. Totals for each employee
c. Total for the quarter
3. Save your file as March Qtr Sales-Task 2-your name in your Accounts Team folder.
4. Add a header and footer as per the style guide on page 6.
5. Apply formatting and borders to your spreadsheet as per the style guide on page 6.
6. Spellcheck and proofread.
7. Print twice – once showing data and once showing formula. Ensure the printouts fit on one page.8. Save and close your file