What would be the results if the Formula =2*C8+3*D9 is entered into a cell if the value displayed in C8 is 3,and the value in cell D9 is 2? Select one: a. 3 b. 18 c. 12 d. 25

The correct answer is:

12 (c)

Explanation:

The codes as shown C8 and D9 represent cells in an Excel spreadsheet. the cell tags describe the column letter and row numbers. For instance; C8 means the 8th row in Column C, while D9 means; the 9th row in column D. In order to do mathematical functions with Excel, the formulae starting with an equal sign (=) like the one shown in this example are used. The function is solved as follows:

= 2*C8+3*D9

where:  

* = multiplication sign (×)

C8 = 3

D9 = 2

∴ 2*C8+3*D9 = (2 × 3) + (3 × 2)

= 6 + 6 = 12

∴ the result is 12