EDUCATOR-LEVEL-1 practice question 22 of 30

What does the function =IMPORTRANGE() do in your Google Sheets document?

Full set: 210 questions
Answer options
A: Imports data from another Google Sheets document. Correct answer
B: Imports data from another sheet in the same document.
C: Imports data from a CSV file.
D: Imports data from a website.
Correct Answer:
A. Imports data from another Google Sheets document.
Explanation

The =IMPORTRANGE() function in Google Sheets is used specifically to import a range of cells from a specified spreadsheet into another spreadsheet. The user must provide the full URL of the source spreadsheet and the range of cells to be imported (e.g., "Sheet1!A1:B10"). The first time this is done between two sheets, the user must grant permission for them to connect.

Why Incorrect

B. Imports data from another sheet in the same document: To do this, you simply reference the sheet name directly (e.g., =Sheet2!A1), no special function is needed.
C. Imports data from a CSV file: This is done through the user interface via File > Import, not with a cell function.
D. Imports data from a website: This requires other functions, such as IMPORTHTML for tables or lists, or IMPORTXML for specific data points.

References

1. Google. (n.d.). IMPORTRANGE. Google Docs Editors Help. Retrieved from https://support.google.com/docs/answer/3093340. (This is the official documentation for the function, defining its purpose and syntax.)

2. Google for Education. (n.d.). Analyze and share data with Google Sheets. Teacher Center - Advanced Training. Retrieved from https://skillshop.exceedlms.com/student/path/18128-advanced-training. (The advanced course covers connecting data across sheets, where IMPORTRANGE is a key function.)

Scroll to Top