Create an Excel Project - IT Assignment Help

Assignment Task:

Task:

Time: 2 hrs... Marks: 40
 Create an excel project using following step by step instruction
 Save your files on the desktop and ensure you give the right name from the following instructions.
 Every cell reference carries marks. So follow the column/ row headings instructions for your work.
Instruction:
Mr. Fence wants you to create a new workbook with the name Sales Forecast.xls for his software company Joe’s Cheap Software Shop. You will have to create a worksheet that calculates the year-end sales forecasts based
on the sales of the company’s three-month products. The only numbers available are for the first three months of this year’s sales figures.
A) Design the presentation of your worksheet
a) You will be using the first eight columns on the worksheet. Make sure that columns B and G are blank.
b) Enter the title in first Row as: Joe’s Cheap Software Shop- Annual Sales forecast
c) Enter the following headings for your columns in the third Row:
Column A: Products
Column C: January
Column D: February
Column E: March
Column F: April
Column H: Year-end-forecast

d) The company sells three main products. These should be in Column “A”.
Row 5: Recycled Software
Row 7: Used Software
Row 9: Software prior to 1984
e) Enter the text Grand Total in cell F12
B) Entering Financial results
a) Enter these figures for the first three months:
Recycled Software: $ 15,894 $ 9,762 $ 13,144
Used software: $ 8,279 $ 9,101 $ 17,202
Software prior to 1984: $ 11,567 $ 13,497 $ 10,912
C) Entering Formulas
a) The fourth month is two times the results of the month of January.
Create a formula in cell F5 to calculate the value for the fourth month
b) Copy the formula from F5 to F7 and F9.
c) Create a Formula in Cell H5, which represents the year?end forecasts based on the results from the first four months, and calculated to reflect a 12? month period. (Hint 3 times the sum of the 4 months)
d) Copy the formula from H5 to H7 and H9.
e) Create a formula in cell H12 that will calculate the grand total of the
year?end forecasts.
D) Fine Tune your worksheet’s Appearance

Make sure that your worksheet is visually well balanced and reflects your professionalism

This IT Assignment has been solved by our IT Experts at My Uni Paper. 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 a 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.