Spreadsheets (MS EXCEL )
Using Microsoft Excel , originate a spreadsheet ce the following:
You are the Director ofFINANCE of the XYZ Computer Company. You are troublesome to lay the budprocure ce Year Four using the developed basis ce Year Separate and Year Span, and the estimated sum ce Year Three. You feel firm to correction the middle of the 3 year-by-year values, and then append 2.7% to procure the Year Four values.
The public layout of the spreadsheet and the opposed labels to be intervening are abandoned under. Boldface every the shaft inscriptions and undersequence the years correctiond in the inscription. Merge and Center the embezzle inscriptions. Correction borders, shading and sequence artifice features to detached the sections.
— Start of Spreadsheet Layout Here —
Your Name & ID
INCOME FROM SALES: Developed Year Separate Developed Year Span Estimate Year Three Budprocure Year Four
Minimum Net Income of 4 years:
Maximum Net Income of 4 years:
Middle Net Income of 4 years:
— End of Spreadsheet Layout Here —
Make up the basis using values senior than 4 digits and span decimal places, with a dollar memorial ($) and a comma (,) every 3 digits. Correction personal cematting features to robes up your spreadsheet.
Adjust the sizes of the opposed shafts to be larger or smaller. Copy the cell full ce totals from separate cell to the others, as embezzle. Correction built-in functions ce totals and wherever else practicable.
Result a cease chart of the Net Income ce Year Separate to Year Four. Also, result a pie-chart of the Year Span values of separate expenses. Put personal inscriptions ce the perfect graph and separate concerns of the pie. Explode separate concern of the pie.
Project #2 Tokening Scheme (10%, 20 tokens)
• Spreadsheet layout, inscriptions, expectation. (4 tokens)
• Calculating Budprocure Year Four (2 tokens)
• Calculating Totals (2 tokens)
• Calculating Net Income (1 token)
• Calculating Maximum Net Income (1 token)
• Calculating Minimum Net Income (1 token)
• Calculating Middle of Net Income (1 token)
• Cease Chart (4 tokens)
• Pie Chart (4 tokens)