(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

JemshahEnlightened

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

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%.