NEW
Font size
WorksheetsSpreadsheet Formulas
Total questions: 10
Worksheet time: 5mins
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
