Please complete Part B of the Final Exam on time and submit it to the online por
Please complete Part B of the Final Exam on time and submit it to the online portal. Also note that, late submissions will not be allowed.
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:
MSOEX1/EX
Column A: Column C: Column D: Column E: Column F: Column H:
Products
January
February
March
April Year-end-forecast
Page 1 of 2
d) The company sells three main products. These should be in Column “A”.
Row 5: Row 7: Row 9:
Recycled Software Used Software Software prior to 1984
e) Enter the text Grand Total in cell F12 B) Entering Financial results
a) Enterthesefiguresforthefirstthreemonths:
Recycled Software: Used software: Software prior to 1984:
C) Entering Formulas
$ 15,894 $ 8,279 $ 11,567
$ 9,762 $ 9,101 $ 13,497
$ 13,144 $ 17,202 $ 10,912
a) ThefourthmonthistwotimestheresultsofthemonthofJanuary. 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) CreateaFormulainCellH5,whichrepresentstheyear‐endforecasts 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
MSO/Exl/Pro/TC
Page 2 of 2