Algebra 1 | Unit 1 | Lesson 8: Spreadsheet Shortcuts | Practice Problems

Open a blank spreadsheet. Use "fill down" to recreate this table of equivalent ratios. You should not need to type anything in rows 3–10.

Evaluate responses using AI:

OFF

A list of numbers is made with the pattern: Start with 11, and subtract 4 to find the next number. Here is the beginning of the list: 11, 7, 3, . . . Explain how you could use "fill down" in a spreadsheet to find the tenth number in this list. (You do not need to actually find this number.)

Evaluate responses using AI:

OFF

Explain what formulas you would enter in cells B4 through B8 so that cell B8 shows a number representing the month and day. (In this example, cell B8 should show 704.) If you have access to a spreadsheet, try your formulas with a month and day to see whether it works.

Evaluate responses using AI:

OFF

Write a formula you could type into a spreadsheet to compute the value of each expression.

Evaluate responses using AI:

OFF

The data set represents the number of cars in a town given a speeding ticket each day for 10 days. What is the median? Interpret this value in the situation.

Evaluate responses using AI:

OFF

The data set represents the number of cars in a town given a speeding ticket each day for 10 days. What is the IQR?

Evaluate responses using AI:

OFF

The data set represents the most recent sale price, in thousands of dollars, of ten homes on a street. What is the mean?

Evaluate responses using AI:

OFF

The data set represents the most recent sale price, in thousands of dollars, of ten homes on a street. What is the MAD?

Evaluate responses using AI:

OFF