Question

participation activity 1.3.7: entering formulas
refer to the spreadsheet below shown in the earlier animation

	a	b	c		d
2	20	3
3	30
4
5

1. what value appears if the formula = a2 + b2 is entered in c2?
2. what formula should be used to find a 15% tip on the $30 bill in cell a3?

spreadsheet functions

Explanation:

Step1: Sum cells A2 and B2

$C2 = A2 + B2 = 20 + 3$

Step2: Calculate the total

$20 + 3 = 23$

Step3: Define 15% tip for A3

15% = 0.15, so formula uses A3

Answer:

1. 23
2. =0.15*A3