LT: Students will learn and understand how to use the google sheets formulas to add, subtract and multiply. *Formulas Addition, Subtraction, Multiplication =SUM(Cell:Cell) =Budget-Total cell =Cell1*Cell2FINISH BBQ Grocery List Assignment. Happy birthday! You are turning 15 and your parents said you can have a birthday BBQ this Saturday, but you can only spend $150 to feed everyone. Your assignment is to buy food, soda, snacks, candy, plastic plates/cups/utensils, a birthday cake and candles for your BBQ! Walmart Grocery - Use Zip Code 97233 *CANNOT spend more than $150.00 *Must be able to feed at least 15 people -Burgers are usually 1/4 pound, so if you buy 1 pound of hamburger, you can feed 4 people *Must tell me how much of each item you are buying *Must buy at least 10 items *5 pictures *Format as Currency *Graph Select Item cells (CTRL) Select Item Total cells *Formula (Item total: =cell*cell) (Total: =sum(cells)) *Header/Title *Column Headers *Capitalize
I will teach you a new formula next class to figure out total cost when buying multiple items Need Help? (BBQ Help Video) Need Help? (With SOUND!) *Like and Subscribe Due Next Class Finished? Turn in BBQ HERE |

Homepage > Digital Literacy Sem 1 2018-19 >