Mastering Spreadsheet Formulas Quiz

What formula would you use to add the values in cells A1 and B1?

• =A1-B1

• =A1+B1

• =SUM(A1:B1)

• =ADD(A1,B1)

If you wanted to calculate the average of the numbers in cells A1 through A5, which formula would you use?

• =AVERAGE(A1:A5)

• =AVG(A1:A5)

• =MEAN(A1:A5)

• =SUM(A1:A5)/5

How would you write a formula to subtract the value in cell B2 from the value in cell A2?

• =A2-B2

• =SUBTRACT(A2,B2)

• =A2+B2

• =DIFF(A2,B2)

Which formula correctly multiplies the values in cells A1 and B1?

• =A1*B1

• =MULTIPLY(A1,B1)

• =A1xB1

• =PRODUCT(A1,B1)

To divide the value in cell A1 by the value in cell B1, which formula should you use?

• =A1/B1

• =DIVIDE(A1,B1)

• =A1÷B1

• =RATIO(A1,B1)

What function would you use to find the square root of a number in cell A1?

• =SQRT(A1)

• =SQR(A1)

• =ROOT(A1)

• =^0.5(A1)

If you want to raise the number in cell A1 to the power of 3, which formula is correct?

• =A1^3

• =POWER(A1,3)

• Both A) and B)

• =A1**3

Which formula correctly calculates the modulus (remainder after division) of A1 divided by B1?

• =MOD(A1,B1)

• =A1 % B1

• =REMAINDER(A1,B1)

• Both A) and B)

To find the absolute value of a number in cell A1, which function would you use?

• =ABS(A1)

• =ABSOLUTE(A1)

• =|A1|

• =ABSVAL(A1)

What function calculates the natural logarithm of the number in cell A1?

• =LN(A1)

• =LOG(A1)

• =LOGN(A1)

• =NLOG(A1)