Module 4 - Quiz 1

3 Questions

Settings
Please wait...
Excel Quizzes & Trivia

.


Questions and Answers
  • 1. 
    In a VLOOKUP, you can pull from multiple columns by adding what to the formula? 
    • A. 

      { }, curly brackets (or "braces")

    • B. 

      [ ], square brackets

    • C. 

      ( ), parenthesis

    • D. 

      You don't need to add any special characters.

  • 2. 
    Can you return data across multiple columns with one VLOOKUP?
    • A. 

      Yes, you can always do this whether it's an array formula or not.

    • B. 

      Yes, but only if it's an array formula.

    • C. 

      No, this is impossible.

    • D. 

      Yes, but only in Excel 2016 and later.

  • 3. 
    What is the required keystroke for an array formula?
    • A. 

      CTRL + SHIFT + ENTER

    • B. 

      SHIFT + ENTER

    • C. 

      ALT + ENTER

    • D. 

      CTRL + SHIFT + A