Spreadsheet Formulas

Google Sheets is what sort of program?

• A document program

• A spreadsheet program

• A presentation program

• A television program

What does a formula do in Google Sheets?

• It automates a process

• It creates a chemical

• It answers a question

• It finds mistakes

What does the =COUNTIF formula do?

• Counts things

• Counts how often something occurs

• Counts how many different things are there

• Counts how many things are in a list

=SPLIT(A2,"/")

In the above formula, what does the "/" tell the formula to do?

• Put a "/" on the end of the A2 cell

• Split the A and the 2

• Divide A2 in half

• Split the data in the cell each time there is a "/".

How do you add a new column?

• Click on the "Edit" menu and choose "Insert Column"

• Click on the "Insert" menu and choose "Column Left" or "Column Right".

• Right-click on the top label of the column and choose "Insert a new column"

• Click on the "Edit" menu and choose "Give me a new column please!"

If I click on this small blue square and drag downwards, what will happen?

• The cells below will be filled with 1, 2, 1, 2, 1, 2, etc.

• The numbers 3, 4, 5, etc will be added to the cells below.

• The cells will get bigger.

• The cells below will only be shaded blue.

What formula would I write in the blue box to count how many students prefer the beach to the pool?

• =COUNTIF(A2:A15,Beach)

• =COUNTIF(A2:A15,"Pool")

• =COUNTIF(A2:A15,Pool)

• =COUNTIF(A2:A15,"Beach")

How do you get something like this in your spreadsheet?

• Select the cells containing the data then click the "Insert" menu then choose "Chart"

• Select the cells containing the data then click the "Edit" menu then choose "Insert Chart"

• Select the cells containing the data then click the "Insert" menu then choose "Pie"

• Click the "Help" button, choose "Report a problem" and then type "My teacher didn't teach me how to do this crazy stuff!".

Which formula below would you use to break a person's full name into a first name and a second name?

• The "BREAK" formula

• The "SPLIT" formula

• The "SEPARATE" formula

• The "CUT" formula

If you want to create a Pie Chart in a spreadsheet, what would be the best type pf question to ask in a form?

• A paragraph question

• A short answer question where the answer must be written as a number

• A multiple choice question with numerical answers

• A checkbox answer with numbers written in words