Identify The Function Names In The Following Formulas

100 Level Computer Science exam questions and the detailed answers. Download the answers in document format. Correct, detailed, and straightforward answers.

Questions:

(a)
(i) Using the right pre-defined function, write out the formula you will use to add figures places in the A3 to F6.

(ii) Assume that the formula =AVERAGE(B4:E7,$G4:G7) in cell H7 is copied to cell J10, what will the formula become?

(iii) If each of the following formulas is entered in cell J1 and then copied to N9, what will it become?

• =SUM($B$4,E8)
• =SUM($B4:E4)
• =SUM(B$5:F5)
• =SUM(C4,G8)

(b) Identify the function names in the following formulas:

(i) =((-B2) + SQRT((B2)^2-(4*A2*C2)))/(2*A2)
(ii) =SUM(A2:A4)
(iii) =ROUND(TAN(T30),3)*SQRT(T31)
(iv) =LOG(V2)
(v) =A25 * EXP(B25) * SIN(C25)
(vi) =Q50*EXP(-Q51*T51)