DIRECTIONS: Create a new GOOGLE SHEET in your FRESHMAN_TECH FOLDER, name it FORMULAS. CLICK the + sign in the lower left corner of Google Sheets to create a NEW SHEET for each problem.

1. Create a simple TABLE just like the one below that shows the square footage of the following rooms in a house. Use the proper FORMULAS to calculate the SQUARE FOOTAGE OF EACH ROOM and the TOTAL SQUARE FOOTAGE of all rooms combined.

ROOMS

SIZE in feet (length x width)

SQUARE FOOTAGE (=length*width)

Living Room

15 x 20

Dining Room

15 x 14

Kitchen

10 x 12

Bedroom

12 x 12

Master Bedroom

16 x 15

Bathroom

5 x 8

Total Square Feet=

2. In your Language Arts class, you have received the following grades for this semester:

Percenta

Assignment

Grade

Total Points Possible

Quiz 1

7

10

Quiz 2

9

10

Quiz 3

10

10

Paper

165

200

Project

78

100

Test

123

150

Extra Credit

12

0

Totals

Percentage Grade (=total grade/total points possible) PUT IN PERCENT FORMAT!

Recreate the table in Google Sheets that shows this data. Use FORMULAS to calculate your TOTAL POINTS EARNED and TOTAL POINTS POSSIBLE. Figure out your percentage grade for last semester, using the formula =TOTAL POINTS EARNED/TOTAL POINTS POSSIBLE.

3. Using Google Sheets formulas, figure out the answers to the following equations. PLEASE WRITE OUT THE PROBLEMS IN A SHEETS CELL, THEN USE THE PROPER FORMULA TO CALCULATE THE ANSWER IN THE NEXT CELL TO THE RIGHT. (for example):

1+2=

Enter Sheets formula: "=1+2"

What is 327*1295.9?

What is 1+2+3+4+5+6+7+8?

What is the price of a single pie, when 12 pies cost $157.95?

Billy has 7 apples, Sam has 4 apples, Joe has 1 apple and Max has 12 apples. What is the AVERAGE number of apples each kid has? (AVERAGE= Total apples divided by number of kids)

You had 158 candy hearts after Valentine's Day. You ate 12 candy hearts on Wednesday, 8 candy hearts on Thursday, 13 candy hearts on Friday and 1 on Saturday. How many do you have left on Sunday, assuming you were selfish and did not give any away or let anyone steal any?

SUBMISSION:Your charts all be created and named as outlined above. The file should be in your FRESHMAN_TECH folder for grading.