But why tho?
Give an example of why you'd need the Find and Replace feature.
E.g., change the word "band" to "marching band"
The purpose of the SUM function
What is to add up all the numbers in a certain range
What is it called when you change the background color of a cell?
What is changing the fill color
True or false, you can have multiple sheets within a Google Sheet.
What is true.
Give an example of why you'd use conditional formatting.
To highlight a number over or under a certain amount, to make a certain word appear in red text, etc.
The purpose of the AVERAGE function
What is to find the average number from a range of numbers.
How can you automatically adjust the width of a column to the width of the words within it?
What is double click the top right portion of the column
Name the two businesses whose products were compared in the second spreadsheet Mrs. M showed you.
What were Starbucks and Dunkin Donuts
Give an example of why you might leave a comment or note.
E.g., reminding yourself or a collaborator that something still needs your attention.
The purpose of the MIN and MAX functions
What is to find the lowest and highest values in a range of numbers.
What is it called when you combine two cells?
What is merging cells
Name the two basketball teams from the first spreadsheet Mrs. M showed you.
What were the Carson County Clobberers and the Groom Goobers
Give an example of why you might use a function
E.g., to total, average, count numeric or text responses.
The purpose of COUNT IF function
What is to count how many cells in a range contain a certain value or word. E.g., count how many cells have the word "Yes" in it for the basketball teams.
The type of formatting you'd use to move the text in a cell to the far left, far right, or center.
What is alignment
Name a drink with a high calorie count from the second spreadsheet
Smoothies, frappuccinos, etc.
Give an example of why you'd use notification rules.
E.g. Mrs. M using a senior tracker and needing to know when a student had updated it - signals her to send a transcript, etc.
The purpose of the IF function
What is to display a certain response IF a cell contains a specified value.
E.g., to say "not enough players" if there are fewer than 10 on a team.
Scenario: you're typing a long comment in your "Notes" column - to the point where you can't see all your text without scrolling over to the right. How can you format the text to make it more readable?
What is text wrapping
All of the players on the basketball spreadsheet are real people. Who is the real identity of the player N. Holt? Hint: player rating was 95, height was 6'4".
Who is Coach Black!