Google Sheets Quiz: From Importing to Analysis

What is the primary purpose of using IMPORTRANGE in Google Sheets?

• To format cells

• To sort data alphabetically

• To import a data range from another Google Sheet

• To calculate the sum of a column

What formula would you use to convert the text "2024-01-01" into a date format?

• CONVERT()

• TEXT()

• DATEVALUE()

• DATEDIF()

The function used to remove specific text from a string is called (a)   .

What shortcut can be used to replace all instances of a word in a selected range?

• Ctrl+C

• Ctrl+H

• Ctrl+Z

• Ctrl+Shift+T

The function = (a)   (A2, B2, "D") calculates the number of days between two dates.

Which of the following imports a .csv file from a public URL?

• IMPORTFILE

• IMPORTCSV

• IMPORTDATA

• IMPORTRANGE

Which pair of functions can you combine to remove a suffix from the end of a text?

• LEFT + LEN

• CONCAT + IF

• RIGHT + MID

• YEAR + SUBSTITUTE

In Google Sheets, the function = (a)   (K2, 'Table'!A:A, 'Table'!B:B, "Region not found") returns a match from a table.

Which of the following formulas correctly applies multiple conditions in the FILTER function to select rows where the location is "Paris area" and the month of the date column is January?

• FILTER(data, location_column="Paris area")

• FILTER(data, MONTH(date_column)=1 AND location_column="Paris area")

• FILTER(data, location_column="Paris area", MONTH(date_column)=1)

• FILTER(data, location_column="Paris", date_column="01")

The QUERY function uses logic similar to (a)   .