Unit 3, Lesson 6
Mystery Computations (Optional)
Integrated Math 1
Practice
Problem 1
What could be the formula used to compute the value shown in cell B3?
= B3 * B4
Sign in to view assessments and invite other educators
Sign in using your existing Kendall Hunt account. If you don’t have one, create an educator account.
What could be the formula used to compute the value shown in cell B3?
= B3 * B4
= A2 + A5
= A2 * A5
= Sum(A2:A6)
to access Practice Problem Solutions.
What number will appear in cell B2 when the user presses Enter?
A spreadsheet with rows 1 to 5 and columns A to B. A 1 contains “change these”. A 2, 10. A 3, 5. A 4, 0. A 5, negative 7. B 1, “what happens here?”. B 2, “equals sum open parenthesis A 3 colon A 5 closed parenthesis”. All other cells are blank.
to access Practice Problem Solutions.
Select all the formulas that could be used to calculate the value in cell B4.
=Product(A2:A6)
=Sum(A2:A6)
= A2 + A3
= A2 * A3
= A3 * A4 * A5
= A3 + A4 + A5
to access Practice Problem Solutions.
The formula in cell B2 is = Product(A2 : A5). Describe a way to change the contents of column A so that the value in cell B2 becomes -70.
to access Practice Problem Solutions.
The dot plot displays the number of books read by students during the semester.
to access Practice Problem Solutions.
The dot plot displays the number of families living in different blocks of a town.
to access Practice Problem Solutions.