Question

the number 3 was typed into cell a1 of a spreadsheet, while in cells a2 through a7, formulas were typed in as shown. if the values produced by the formulas were displayed in the spreadsheet, instead of the formulas themselves, what would be the value displayed in cell a7? a 25 b 28 c 75 d 83

Explanation:

Step1: Identify value of A1

A1 = 3

Step2: Calculate A2

A2=12 + A1=12 + 3=15

Step3: Calculate A3

A3=12 + A2=12+15 = 27

Step4: Calculate A4

A4=12 + A3=12 + 27=39

Step5: Calculate A5

A5=12 + A4=12+39 = 51

Step6: Calculate A6

A6=12 + A5=12+51 = 63

Step7: Calculate A7

A7=12 + A6=12+63 = 75

Answer:

C. 75