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.

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.)

Tags

CCSS.HSF.BF.A.2

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.

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

Tags

CCSS.6.EE.A.2C

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.

Tags

CCSS.6.SP.B.5C

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

Tags

CCSS.6.SP.B.5C

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

Tags

CCSS.6.SP.B.5C

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

Tags

CCSS.6.SP.B.5C