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

This Accounting Assignment has been solved by our Accounting Experts at Exam Question Bank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.