Unit 1, Lesson 6
Mystery Computations
Algebra 1
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.
Navigate to this activity in the digital version of the materials, or to ggbm.at/fjcybyqf.
Input different numbers in column A, and try to predict what will happen in column B. (Do not change anything in column B.)
Spreadsheets are useful mathematical and statistical tools. Here is an example of a spreadsheet. Each cell in the spreadsheet can be named with its column and row. For example, cell B2 contains the value 99. Cell A4 contains the value -17. Cell D1 is selected.
It is possible for the value in a cell to depend on the value in other cells. Let's type the formula = B2 – D5 into cell D1.
When we press enter, D1 will display the result of subtracting the number in cell D5 from the number in cell B2.
If we type new numbers into B2 or D5, the number in D1 will automatically change.