Google Sheets Quiz: From Importing to Analysis
Authored by Catriona Beamish
Computers
Professional Development
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula would you use to convert the text "2024-01-01" into a date format?
CONVERT()
TEXT()
DATEVALUE()
DATEDIF()
3.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
The function used to remove specific text from a string is called (a) .
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
5.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
The function = (a) (A2, B2, "D") calculates the number of days between two dates.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following imports a .csv file from a public URL?
IMPORTFILE
IMPORTCSV
IMPORTDATA
IMPORTRANGE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
