EDUCATOR-LEVEL-1 practice question 22 of 30
What does the function =IMPORTRANGE() do in your Google Sheets document?
Full set: 210 questionsThe =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.
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.
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.)
Keep practicing
Take the free EDUCATOR-LEVEL-1 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other EDUCATOR-LEVEL-1 practice questions
- Question 1Which function would you use to find the lowest value in a range of cells?
- Question 2What is the shortcut key to wrap text within a cell?
- Question 3What is the Google feature that allows you to limit your search results to pages that hav…
- Question 4What is the process for integrating Meet with Google Classroom?
- Question 5What is the shortcut to undo an action in your Google Sheets document?
- Question 6Which type of external content can you easily insert into a Google Doc using smart chips?
