We're Open
+44 7340 9595 39
+44 20 3239 6980

[Solved]8)Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this,

  100% Pass and No Plagiarism Guaranteed

[Solved]8)Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.

Required:

1)      Using excel, and the data provided on the previous page, open a new spreadsheet in excel and replicate the spreadsheet below where you will see the format we require.  Show the asset allocation, returns and weighted returns for both the BCG Balanced fund and the BCG Growth fund. (Save the spreadsheet for submission.)

 

  • Ensure that formulae are used in the excel spreadsheet to find the ‘Total’ asset allocation of 100% .
  • Use formulae in the excel spreadsheet to calculate the weighted returns for each funds.
  • Use formulae in the excel spreadsheet to calculate the total weighted return for each fund.

 

2)      Create a pie chart for each fund showing the asset allocation of each fund.

  • Include a legend showing which asset class each colour represents
  • Include data labels on the pie charts to show the actual percentages allocated to each asset class
  • Include a title for each fund

 

3)      Write the formula in the box below that you used in the cell that gives the Total as being 100%  (cell C8)

 

 

 

 

4)      Write the formula in the box below that you used in the cell that gives the weighted return for Cash in the BCG Balanced Fund  (cell E2)

 

 

 

5)      Write the formula in the box below that you used in the cell that gives the Total weighted return for the BCG Growth Fund  (cell E22)

 

 

6)      When looking at a cell reference, how do you know if the cell is a “relative” cell reference in excel or an ‘’absolute” cell reference in excel?  Remember, you can google or youtube this, in addition to the notes we have provided in Appendix 5 if you need additional help.

 

7)      Provide an example of when you might use a relative cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help. 

 

8)      Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.

 

9)      Explain what is meant by a weighted return.

 

10)      Ensure you submit your excel spreadsheet including the pie chart when you submit your assignment.


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved]8)Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.
  • Price: £ 119
  • Post Date: 2021-10-15T13:02:15+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]8)Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help. [Solved]8)Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I am not good at designing PowerPoint presentations so I took help from Insta Research. The format is cool and attractive. All the information is nicely placed and used. I am looking forward to presenting so that I could demonstrate my presentation and receive good comments. Thank you for help.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Now I am happy that I made the right decision of coming to Insta Research for help. My term paper was so technical and analytical at the same time. I got really confused about what to do but got relaxed when I was given such a humble writer. He clarified my concepts with the best explanations and discussions. I almost interacted with him on daily basis within the writing process. The best feature of this site is quick delivery as I got the work before my deadline. Additionally, the term paper is written skillfully and handled quite professionally. Now I am able to take a deep sigh of relief and thank you all for such speedy help. The quality of the work made my day.