ICT Spreadsheet Essentials - Lesson 3

Consider the following formula:

=(H12*H13)/H14

What does this formula accomplish?

• It divides the value in Cell H12 by the value in Cell H13, and then multiplies the total by the value in Cell H14.

• It multiplies the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

• It subtracts the value in Cell H13 from the value in Cell H12, and then multiplies the total by the value in Cell H14.

• It adds the values in Cells H12 and H13, and then divides the total by the value in Cell H14.

What value would be the result of the formula =A2/B2 in the spreadsheet shown?

• 32

• 2

• 4

• 12

Which of the following is an example of an absolute cell reference?

• F5:E5

• F4

• $A$5

• D5+F5

Aman wants to multiply the values in cells B2 and B3, and then divide the total by the value in cell D7. Which of the following would be the correct formula?

• =(B2*B3)%D7

• =B2*B3-D7

• =(B2*B3)/D7

• =(B2xB3)/D7

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

• $B7 is a mixed cell reference in which the column would not change when moved.

• $B7 is a relative cell reference in which the row would not change when moved.

• $B7 is an absolute cell reference in which the row would not change when moved.

• $B7 is an example of an absolute cell reference in which the column and row would not change when moved.

Charles is working with several team members on the same spreadsheet. He wants to use an absolute cell reference for the data in cell C7 in one of his formulas. Which of the following is an example of how he would make this absolute cell reference?

• &C7

• C7

• $C$7

• C+7

Helen used a formula to calculate values using the data in Column A and the data in Column B. Which formula did Helen use in Column C to produce the result in Cell C1?

• =A1+B1

• =A1/B1

• =A1*B1

• =A1-B1

Which formula would produce an exponent?

• =Exponent(B2)

• =B2^2

• =B2/B4

• =B2*2

Sharla wants the cube of the number from C5 to be displayed in D5. Which formula would she use in D5 to produce the number using the exponent?

• =Exponent3(C5)

• =B2*3

• =C5/D5

• =C5^3

Which example is an absolute cell reference that would not change the column and row when moved?

• $C8

• C8

• $C$8

• C$8