CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

What type of functions are included in the Lookup and Reference categ…

What type of functions are included in the Lookup and Reference category?

Answer & explanation+

Correct answer: option 1

The correct answer is option 1- Functions for searching and linking data.

The LOOKUP function returns a value either from a one-row or one column range or from an array. The LOOKUP function has two syntax forms: vector and array. The Look Up function can be used as an alternative to the IF function for elaborate tests or tests that exceeds the limit for nesting of IF functions. 

The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value, and then returns a value from the same position in a second one row or one-column range.

The array form of LOOKUP looks in the first row or column of an array for the specified value, and then returns a value from the same position in the last row or column of the array.

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. Choose the correct order for the formation of p-n junction diode.(A) diffusion current(B) drift current(C) formation of space charge region…Physics · Semiconductors and Electronic Devices
  2. The probability that A hits a target is displaystyle1/5 and the probability that B hits it is displaystyle2/3 . The probability that the ta…Maths. Section B1 · Probability
  3. Read the given statements and conclusions carefully. Assuming that the information given in the statements is true, even if it appears to b…General Aptitude Test · Verbal Reasoning
  4. Select the most appropriate meaning of the given idiom. Chase rainbowsEnglish · Grammar: Idioms
  5. सूची -I को सूची -II से सुमेलित कीजिए :सूची -I स्थायी भावसूची -II रस(A). निर्वेद(I). वीर(B). शोक(II). भयानक(C). उत्साह(III). शांत(D). भय(IV)…Hindi · व्याकरण - रस
  6. Which city does not have Jantar Mantar observatories built by Jai Singh II in the early 18th century?General Aptitude Test · General Knowledge
  7. The wives of Mughal Kings who were not of noble origin were referred to as:History · Medieval India: Kings and Chronicles
  8. What are the dimensions of E/B , where E and B are the electric and magnetic fields of an electromagnetic wave?Physics · Electromagnetic Waves
  9. A manufacturer has employed 5 skilled men and 10 semi-skilled men and makes two models A and B of an article. The making of one item of mod…Applied Maths. Section B2 · Linear Programming
  10. A 2-ton vehicle travels at 20m/s on a road where the frictional force is 10% of the weight of the vehicle. What is the power required? (Ass…Physics · Work Power Energy