XYZ Computer Company

 
Spreadsheets (MS EXCEL )

Using Microsoft Excel , originate a spreadsheet ce the following:

Don't use plagiarized sources. Get Your Custom Essay on
XYZ Computer Company
Just from $13/Page
Order Essay

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 —

Company Name
Your Name & ID
INCOME FROM SALES: Developed Year Separate Developed Year Span Estimate Year Three Budprocure Year Four
PC Hardware
Network Hardware
SOFTWARE

Don't use plagiarized sources. Get Your Custom Essay on
XYZ Computer Company
Just from $13/Page
Order Essay

TOTAL INCOME

EXPENSES:
Network Purchase
Staff Salary
Misc.
TOTAL EXPENSES

NET INCOME:

Minimum Net Income of 4 years:
Maximum Net Income of 4 years:
Middle Net Income of 4 years:

Don't use plagiarized sources. Get Your Custom Essay on
XYZ Computer Company
Just from $13/Page
Order Essay

— 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.

Don't use plagiarized sources. Get Your Custom Essay on
XYZ Computer Company
Just from $13/Page
Order Essay

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)

TOTAL: /20

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal