Excel_3e_investment | Computer Science homework help



Open the Excel workbook Student_Excel_3E_Investment_AS.xlsx downloaded   with this project.


In cells B10 and C10, enter   formulas to calculate totals for each column.


In cell D5, construct a formula   to calculate the % of Total Projected Investments for Pooled Investments by   dividing the Projected Investments for Next Fiscal Year for Pooled   Investments by the Total Projected Investments for Next Fiscal Year. Use   absolute cell references as necessary, format the result in Percent Style,   and Center the percentage. Fill the formula down through cell D9.


Select the nonadjacent ranges   A5:A9 and C5:C9 as the data for a pie chart, and then insert a 3-D Pie chart.   Move the chart to a New chart sheet named Projected Investments


For the Chart Title, type Projected   Revenue. Format   the Chart Title by applying a WordArt style. In the first row, apply the   second style. Change the Font Size to 32.


Remove the Legend chart element,   and then add the Data Labels chart element formatted so that only the   Category Name and Percentage display positioned in the Center.


Change the Font Size of the data   labels to 12, and then apply Bold. Format the Data Series using a 3-D Format   effect. Change the Top bevel and Bottom bevel to the last bevel style in the   last row. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height   to 0. Change the Material to the third Standard Effect, Plastic.


Display the Series Options, and   then set the Angle of first slice to 100 so that the Pooled Investments slice is in the   front of the pie. Select the Pooled Investments slice, and then explode the   slice 10%. Change the Fill Color of the   Pooled Investments slice–in the fifth column, apply the fourth color. Format   the Chart Area by applying a Gradient fill using any Preset gradient style.



Format the Border of the Chart   Area by adding a Solid line border—in the fifth column, apply the first   color. Change the Width to 5 pt.


Display the Page Setup dialog   box, and then for this chart sheet, insert a custom footer in the left   section with the file name.


Display Sheet1 and rename the   sheet as Investment Sources. Click in any blank cell to cancel any selections.   In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the   text across the range A12:D12. Apply the Heading 3 cell style. In cell A13,   type Goal   Amount.


Copy the range C6:D6 to cell   B13. Click cell C13, and then use Goal Seek to determine the projected amount   of Endowment Investments in cell B13 if the value in C13 is 10%.


Select the range A13:C13, and   then apply the 20% – Accent4 cell style. In B13, from the Cell Styles   gallery, apply the Currency [0] cell style.


From the Page Setup dialog box,   center the worksheet Horizontally, and then insert a custom footer in the   left section with the file name.


Save and close the file, and   then submit for grading.

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Quality Essay Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Quality Essay Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.