Complete the formula to import data from another spreadsheet using IMPORTRANGE.
=IMPORTRANGE([1], "Sheet1!A1:B10")
The first argument of IMPORTRANGE is the URL or the spreadsheet key in quotes. Here, the full URL in quotes is correct.
Complete the formula to import range from a spreadsheet key instead of full URL.
=IMPORTRANGE([1], "Data!C1:D20")
The spreadsheet key must be a text string in quotes as the first argument.
Fix the error in the formula to correctly import data from another spreadsheet.
=IMPORTRANGE([1], "Sheet1!A1:B5")
The first argument must be a text string with quotes. Also, the second argument (range) must be in quotes. Here, the blank is for the first argument, so the correct answer is the URL in quotes.
Fill both blanks to import data from a spreadsheet key and specify the correct range.
=IMPORTRANGE([1], [2])
The first argument is the spreadsheet key in quotes, and the second argument is the range also in quotes.
Fill all three blanks to create a formula that imports data and uses ARRAYFORMULA to double the values in column A.
=ARRAYFORMULA(IMPORTRANGE([1], [2]) * [3])
The IMPORTRANGE uses the spreadsheet key and range in quotes. The ARRAYFORMULA multiplies the imported column by 2 to double the values.