Web
=IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])
Quiz =IMPORTTEXT — 10 Questions
10 quiz questions about =IMPORTTEXT — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
What is the type of argument “delimiter” in =IMPORTTEXT?
Explanation: Type of “delimiter” is “Text”.
Question 2 of 10
2/10
What is the type of argument “path” in =IMPORTTEXT?
Explanation: Type of “path” is “Text”.
Question 3 of 10
3/10
Since which Excel version is =IMPORTTEXT available?
Explanation: Version: “Microsoft 365”.
Question 4 of 10
4/10
Is =IMPORTTEXT volatile?
Explanation: IMPORTTEXT is not volatile.
Question 5 of 10
5/10
Does =IMPORTTEXT return a dynamic array?
Explanation: IMPORTTEXT spills as a dynamic array.
Question 6 of 10
6/10
In =IMPORTTEXT, which is argument #2?
Explanation: Argument #2 is “delimiter”.
Question 7 of 10
7/10
Is argument “locale” required in =IMPORTTEXT?
Explanation: “locale” is required.
Question 8 of 10
8/10
In =IMPORTTEXT, which is argument #3?
Explanation: Argument #3 is “skip_rows”.
Question 9 of 10
9/10
Which function is NOT related to =IMPORTTEXT?
Explanation: “MODE” is not related to IMPORTTEXT.
Question 10 of 10
10/10
How many optional arguments does =IMPORTTEXT have?
Explanation: =IMPORTTEXT has 6 required, 0 optional (6 total).