GoSkills
  • Courses
  • Courses
    • Train your organization. Train your organization Supercharge your organization with expert-led business and productivity courses. Learn more
    • Learn on your own. Learn on your own Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses. Learn more
    • Explore our courses. Explore our courses Browse our award-winning library of 100+ business and productivity courses delivered in bite-sized lessons. Explore courses
  • LMS
  • Course builder
  • Resources
  • Pricing
    • Organization pricing
    • Individual pricing
  • Pricing
  • Search
Sign upLog in
  • Log in Signup

Quiz

  1. 1
    Advanced

    Suppose there is a small table with these values for the cells: A1 = A, A2 = B, B1 = C, B2=D. What does the formula =INDEX(A1:B2,2,1) return?

    Supporting image for quiz question

    Supporting image for quiz question
  2. 2
    Advanced

    Suppose cells A1:A4 contain these values: Fred, Joe, Mary, John. What does the formula =MATCH(“joe”,A1:A4,FALSE) return?

    Supporting image for quiz question

    Supporting image for quiz question
  3. 3
    Advanced

    Suppose cells A1:A4 contain these values: Fred, Joe, Mary, John. What does the formula =HLOOKUP(“joe”,A1:A4,1,FALSE) return?

    Supporting image for quiz question

    Supporting image for quiz question
Previous question Previous Next question Next
Give feedback

How is your GoSkills experience?

I need help

Your feedback has been sent

Thank you

Back to the top

© 2023 GoSkills Ltd. Skills for career advancement