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
  • Browse all papers
  • 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

On the ribbon of MS Excel, the formula tab contains which of the foll…

On the ribbon of MS Excel, the formula tab contains which of the following categorised functions?

Answer & explanation+

Correct answer: option 1

The correct answer is Option (1) → Lookup and Reference Function

NCERT (2026-27 edition):
OTHER USEFUL FUNCTIONS – “In business applications the input of data usually contains dates (date of invoice preparation, date of payment, payment received date, or due date etc.), rate of interest, tax percentage and output information may require age calculation, duration, delays in payment, accumulated interest, depreciation, future value, net present value, etc. … On the ribbon of MS Excel, the formula tab contains categorised function libraries ….
a. Date and Time Function.
b. Mathematical Function.
c. Text Manipulation function.
d. Logical Function (other than IF).
e. Lookup and Reference Function.
f. Financial Function.”

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. In which of the following places is the difference between the day and night temperature likely to be the highest ?General Aptitude Test · General Knowledge
  2. Physics · Current Electricity
  3. What is the process in which a backward caste imitates customs and practices of a higher caste to achieve social mobility? Who coined that…Sociology · Indian Society: Continuity and Change
  4. Which of the following Act passed in India is not related to the protection of the environment or resources?Political Science · Contemporary World Politics: Environment and Natural Resources
  5. A wire of resistance R is stretched till its length is double of the original wire. Then, the resistance of the stretched wire is:Physics · Current Electricity
  6. Which of the following is not a source of pollution?General Aptitude Test · General Knowledge
  7. Who was the Vice-President of India in 1969?Political Science · Politics in India Since Independence: Challenges to and Restoration of the Congress System
  8. Who was the male flag bearer for the Indian contingent for closing ceremony of Paris Olympics 2024?General Aptitude Test · Current Affairs
  9. The area of a rectangle is 216 m2 and its length is 6 times of its breath. The perimeter of the rectangle is:-General Aptitude Test · Quantitative Reasoning
  10. In the case of a dissolution of a firm, accumulated losses are transferred to:Accountancy Part A · Dissolution of Partnership Firm