Home/ Questions/Q 3848
Next
In Process
Jemshah
  • 0
Enlightened
Asked: 2023-01-20T20:17:10+00:00 In:

(b) Peter entered value 25 in cell Al in a spreadsheet program. Write a formula that could be used to increase this value by 20%. (2 marks)November 2022

  • 0

(b) Peter entered value 25 in cell Al in a spreadsheet program. Write a formula that could
be used to increase this value by 20%. (2 marks)November 2022

You must login to add an answer.

Need An Account,

1 Answer

  1. Enlightened

    The formula to increase the value of cell Al by 20% could be:

    =Al*1.2

    This formula multiplies the value in cell Al by 1.2, which is the equivalent of increasing the value by 20%.

    Another way to write the formula would be

    =Al+Al*0.2

    This formula is adding the value in cell Al to the result of Al multiplied by 0.2 which is also equivalent of increasing the value by 20%.

    • 0