5th Grade Database Search and Sheets 2 QUIZ

What do you select before choosing a function in Google Sheets?

• The cell range you want to apply the function to
• The color of the cells
• The font style of the text
• The size of the cells

What function command would you use to add together the value for a group of cells?

• =MIN()
• =MAX()
• =SUM()
• =AVERAGE()

What function command would you use to find the smallest value in a group of cells?

• =SUM()
• =MIN()
• =MAX()
• =COUNT()

What function command would you use to find the largest value in a group of cells?

• =AVERAGE()
• =SUM()
• =MIN()
• =MAX()

How can using the functions in Google Sheets be helpful in adding together large numbers quickly?

• They look pretty
• They automate calculations
• They change the font color
• They organize your files

Which one is an example of a database?

• Google Sheets
• Spotify
• Netflix
• Wikipedia

Which search strategy involves using AND, OR, or NOT?

• Boolean operators
• Exact match
• Wildcard search
• Fuzzy search

Which tool would you use if you wanted to search for all forms of the word "America" (including plurals, etc.)?

• Quotation marks
• Asterisk

• Boolean operators
• AMERICA

What tool would you use to search words together, like "science experiment"?

• Parentheses
• Wildcard
• Quotation marks
• Boolean operators

What would be the best way to search for a specific science experiment related to refraction?

• Search "science experiment"
• Use science experiment OR refraction
• Use science experiment AND refraction
• Search refraction experiment