Question

A spreadsheet has some values entered: Cell A1 contains 10, cell A2 contains 14, cell A3 contains 7. You enter in cell A4 the following: =1+2. What value is displayed in A4? a 3 b 10 c 14 d 24

Answer 1

The formula excerpt is an excel syntax which sums the value the values in cell A1 and 2. Hence, the output displayed in A4 will be 12

Excel begin with the equal to sign (=). The expression adds the value in A1 and 2.

Since, the value in A1 = 10

What the expression does is ; 10 + 2 = 12.

Therefore, the output displayed in cell A4 is 12.