WorksheetsICT Spreadsheet Essentials - Lesson 3
Total questions: 26
Worksheet time: 26mins
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
Which function is used to total the values of a series of cells?
Average
Count
Max
Sum
Study the image. Which function is calculating the value in cell B6?
=TOTAL(B2:B5)
=COUNT(B2:B5)
=SUM(B2:B5)
=AVERAGE(B2:B5)
Which formula would produce the sum of cells J5 through J9?
=SUM(J5:J9)
=SUM(J1:J10)
=ADD(J5:J9)
=PLUS(J5:J9)
Which formula would produce the average of the values in cells D5 through D9?
=AVERAGE(D5:D9)
=COUNT(D5:D9)
=ADD(D5:D9)
=SUM(D5:D9)
Serena wants to add the numbers appearing in cells D3:D9 and then place the result in cell D10. What function should she use in cell D10 to get the desired result?
=AVERAGE(D3:D9)
=COUNT(D3:D9)
=SUM(D3:D9)
=ADD(D3:D9)
Consider the following spreadsheet function:
=SUM(G2:G19)
What will be the result of this function?
The highest and lowest values that appear in cells G2:G19
The total of the values in cells G2:G19
The number of values that appear in cells G2:G19
The average of the values that appear in cells G2:G19
Derrick has created a spreadsheet that displays the results of a science experiment for Mrs. Blue's class. He needs to write a formula that displays the highest cell value within a data range. Which formula would produce the correct result?
=MAX(J5:J9)
=MOST(J5:J9)
=HIGHEST(J5:J9)
=MIN(J5:J9)
Which formula would calculate the average number of shots taken, as shown in the spreadsheet?
AVERAGE(B2:B6)
AVERAGE(A1:A6)
COUNT(B2:B6)
MAX(B2:B6)
Darryl found this formula in his group's science spreadsheet.
=MAX(J5:J9)
What does this formula display?
It displays the average value within a data range.
It displays the preset maximum possible value for any cell within a data range.
It displays the sum of all cells within a data range.
It displays the highest cell value within a data range.
Column A contains 12 student names. Column B contains each student's weight. Which formula would calculate the average weight of all 12 of the students?
COUNT(B1:B12)
AVERAGE(B1:B12)
AVERAGE(A1:B12)
MAX(B2:B6)
Ella has recorded monthly expenses in her budget spreadsheet project. She needs to add all of the dollar amounts in the cell range of F4:F14 and then display the results in cell F16. What should Ella do to perform this task?
She should select cell F16 and input =ADD(F4:F14)
She should select the cell range F4:14 and input =ADD(F16)
She should select the cell range F4:14 and input =SUM(F16)
She should select cell F16 and input =SUM(F4:F14)
Garret wants to add all of the values from cell C7 through C21. Which spreadsheet function should he use?
=SUM(C7:C21)
=ADD(C7:C21)
=(C7+:+C21)
=(C7:C21)TOTAL
Consider the data in the example spreadsheet:
What can you determine about the highlighted data in Rows 2, 3, and 5?
The spreadsheet has been conditionally formatted to highlight data values greater than $299.
The spreadsheet has been conditionally formatted to highlight data values less than $651.
The spreadsheet has been conditionally formatted to ignore the data values in Rows 2, 3, and 5 only.
The spreadsheet has been conditionally formatted to highlight data values in Rows 2, 3, and 5 only.
Bjorn has created a large spreadsheet that contains multiple columns and rows of data. His boss has requested that he ensure there are no duplicate values in the spreadsheet. What could Bjorn use to automatically highlight cells containing specific text within his spreadsheet?
Cell shading
Absolute reference
Minimum value
Conditional formatting
Carlos has created a large spreadsheet for class. The spreadsheet contains multiple columns and rows of data. Some of the data has not been entered and is therefore blank. What can Carlos do so that the empty cells will be highlighted in yellow until data is entered?
He can use absolute reference.
He can use cell shading.
He can use conditional formatting.
He can use minimum value.
Rosie's group has done some conditional formatting to their budget project. Which rows display the results of the conditional formatting?
None.
Rows 2:8.
Rows 2, 3 and 5.
Rows 4 and 6:8.
