We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

See Pricing

What's Your Topic?

Hire a Professional Writer Now

The input space is limited by 250 symbols

What's Your Deadline?

Choose 3 Hours or More.
2/4 steps

How Many Pages?

3/4 steps

Sign Up and See Pricing

"You must agree to out terms of services and privacy policy"
Get Offer

EXCEL Final Project Essay

Hire a Professional Writer Now

The input space is limited by 250 symbols

Deadline:2 days left
"You must agree to out terms of services and privacy policy"
Write my paper

Number of shares 6. Dollar amount invested* Information for combined purchases: 7. Total dollar amount invested* (AD) 8. Total number of shares* (TTS) 9. Average cost of one share* (AD) divided by (TTS) DESIGN a Stock Quotes worksheet to track your investments Stock quotes information: Title: Stock Quotes & Totals Include columns for date and your 5 companies. ; Add columns for each company s current total value. ; Add a column for the combined total. Rows will increase with added quotes. Use borders and shading. Rename Sheet 2 tab–Coquettes.

1. Names of each of 5 companies 2. Numbers of shares purchased .

Don't use plagiarized sources. Get Your Custom Essay on
EXCEL Final Project
Just from $13,9/Page
Get custom paper

Dates and closing prices (Look at am-?opening or porn=closing) Stock Totals information: 4. Current total value* for each company 5. Total investment value* for all companies on a given date (AD * Current Price) COMPLETE a Stock Sales worksheet Add each company’s final sales information: Create a copy of your Stock Portfolio spreadsheet and move it to the end of your workbook ; Change the title of the spreadsheet to Stock Sales Insert rows and merge cells as needed Use formulas to arrive at *numbers Check formulas for correct cell references ; name from Portfolio (2) oatcakes Change the sheet tab

Current selling price of one share for each company (the price today not the FIRST day) Total dollars received from sale of all shares for each company* (Total Investment Value = Total dollars received) Profit or loss for each company* (Check the value daily to see your gains or losses.

Example if day 1 your stock is worth 5 and the next day it is worth 4 you have lost profit) Add information for combined sales: Total dollars received from sale of all stocks in portfolio* Total combined profit or loss for all companies* CREATE Charts toiletries your data Create 3 types of charts: 1. Line Chart 2.

Column chart 3. Pie charts Data source: Stock Quadruplicates Show price fluctuation over investment period ; Use different color line for each company ; Use labels and background color Embed in Stock Quotes spreadsheet Data source: Stock Sales spreadsheet Show beginning and ending value efface investment (total value, not share price) Save as separate sheet in the workbook ; Name sheet tab-?Columnar On first pie chart, show beginning stock value of each investment Show ending values on the second pie chart ; Embed pie charts in Stock Salesperson’s. Be thoughtful about this work:

Use Print Preview often to see how your page is really looking. Always check formulas in the Formula Bar for correct cell references and other kinds Of information. Your teacher may ask to see a version of your table showing the formulas in your cells. Go to Tools > Options > View: in Window options, check Formulas. Final Project Requirements: a. ) Title page (Using Microsoft Word) b. ) Table of contents c. ) Format each of your worksheets using grid lines, page border, shading and vertical and horizontal centering. Complete your project so it looks as professional as you can make it.

Cite this EXCEL Final Project Essay

EXCEL Final Project Essay. (2018, Apr 07). Retrieved from https://graduateway.com/excel-final-project/

Show less
  • Use multiple resourses when assembling your essay
  • Get help form professional writers when not sure you can do it yourself
  • Use Plagiarism Checker to double check your essay
  • Do not copy and paste free to download essays
Get plagiarism free essay

Search for essay samples now

Haven't found the Essay You Want?

Get my paper now

For Only $13.90/page