In Google Sheets, which function enables a data analyst to specify a range of cells in one spreadsheet to be duplicated in another?

• A. VLOOKUP
• B. FILTER
• C. IMPORTRANGE
• D. SORT

Answer: (C)

Cross-workbook data sharing in Google Sheets is handled by a function that pulls a specified range from a different spreadsheet into your current one. This function lets you specify the source spreadsheet (by URL or key) and the exact range to import, so the data appears in your sheet and stays synchronized as the source updates.

This is the function that enables duplicating a range across files. The other options serve different purposes: VLOOKUP looks up a value in a table and returns related data within the same or another sheet but doesn’t pull a range from another spreadsheet by itself; FILTER returns a subset of a range (often within the same file, though it can act on imported data); SORT reorders data in a range without pulling data from another spreadsheet.