Sum & Filter
Nutrition
Scale & Ratio
Decimals
Challenge
100

When writing a filter function, what comes after filter?

A parenthesis (

100

What do you need to drink everyday to maintain good health?

Water

100

What is a scale?

A comparison between a model and a real-life measurement.

100

Which place is the 8 in: 

1,347.8920

Tenths place

100

What is the rule for rounding a decimal?

5 or more, raise the score. 4 or less, let it rest.

200

Write a SUM function.

=SUM(x*y)

200

What should take up the most space on a balanced plates?

Veggies

200

What is the ratio of boy students to girl students when everyone is present?

7:9

200

1.13 +7.63

8.76

200

What is 2.01 x 1.1?

2.211

300

What is the information you are filtering through called?

Range

300

What should take up the least amount of space ON a balanced plate?

Fruits

300

If my model house is 2 ft tall and my real house is 16 feet tall, what is the scale?

2:16 or 1:8

300
What whole number would you round 531.469 to?

532

300

A decimal place 6 places to the right of the decimal.

What is millionths?
400

What is the data called that determines if you pull data or not?

Condition

400

Which do you need the least of on a balanced plate: oil, fruit, or veg?

Oil

400

If my ratio is 2 tablespoons coffee to 3 cups of water, and I have 6 cups of water, how many tablespoons of coffee do I need?

4

400

What are decimals?

Part of a whole or less than one.

400

Do you need fat in your diet?

Yes

500

Write a filter for page name Pizza and the condition of pepperoni

=filter('Pizza'!A2:d,'Pizza'!d2:d="pepperoni")

500

Eggs, poultry, and fish are examples of what kind of protein?

Good/lean protein

500

The map I'm using has a 1:25,000 in. scale. On the map, my school is 1.5 inches away from my mom's work. How far is it in real life, in FEET?

3,125 feet

500

Write 0.123 as a fraction.

123/1000

500

Name all the categories of nutrition, not just the overarching ones.

Water, carbs, fats, minerals, vitamins, and proteins