Cima C03 Exam Question No 25

Question No 25:

Enter the formula required in Excel to perform the following calculation to the specified decimal places in each case:
37/9 X 4.34 ( to 2d.p)


=ROUND(37/9*4.34,2)

Cima C03 Exam Question No 24

Question No 24:

A group of 10 people share the cost of a new year`s eve for 40 friends. The price of the meal per person is £20 plus £4 for wine and £2 for coffee. Calculate the amount each of the 10 will need to pay. Write down a formula which could be input into one cell in Excel to calculate the amount that the 10 will need to pay.
=40*(20+4+2)/10)

Cima C03 Exam Question No 23

Question No 23:

Below is an extract from an Excel spreadsheet?

For the given data, give the Excel formulae that would be required in Excel to calculate the ROI and NPV in cells B10 and B11 respectively.

Answer: ROI= Average(B2:B5)/B1 NPV= NPV(B7,B2:B5)-B1