Google Sheets Basics lesson

Google Sheets
What to know

Discuss with pod...

1) What is a row? (C or 7)

2) ​What is a column? (C or 7)

3) Why is the cell called C7?

​Parts of a sheet

Multiple Choice

Which is the row?

• C

• 7

• C7

Multiple Choice

Which is the column?

• C

• 7

• C7

You can write formulas to make it for you. All of our calculations must start with an equals sign = and have parentheses in it. Watch this video.....

​Google Sheets will do the math for you!

Multiple Select

What two signs (symbols) must be used to write a formula in Google Sheets? (pick 2) Hit submit button to turn in your answer

• Equal sign =

• ( parenthesis)

• • addition sign +

• multiplication symbol x

This is similar to what you are going to be working with. So in your group
be able to answer these questions:
1) How many males 0-4 years of age are there in Country C?
2) In what cell did you find the answer for question #1?
3) What is the total population for Country C?

​So lets put it together

Match

Match the following​ to the correct numbers or cell.

• Total population

• Total Number of Males 0-4

• In which cell is the formula written to calculate the % of 0-4 males in this graph

• In which cell do you find the number of males 0-4 in this country

318892103

10597149

C3

B3

• 318892103

• 10597149

• C3

• B3

Well, we used
=(age group/total population)*-100 for our males. See how the formula is typed into cell C3? Once I hit enter the program will do the math for me!

​Ok, so how did we calculate males 0-4?

Here is what it looks like after I hit enter in cell C3

Drag and Drop

Correctly add the numbers into this formula =(​

Placeholder

/​

Placeholder

)*​

Placeholder

Drag these tiles and drop them in the correct blank above

10597149

318892103

-100

​One last thing to remember....

We only multiple by - 100 for males. For females we will multiply by 100..... Someone in your pod remember this please....