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 categorised funct…

On the ribbon of MS Excel, the formula tab contains categorised function libraries. Which of the following is not a function in the formula tab?

Answer & explanation+

Correct answer: option 2

The correct answer is option 2- Presentation function.

Presentation function is not a function in the formula tab.

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. The MS Excel provides library of such functions in which input data can be worked as arguments and result available from the function will be output information. 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.

The complete details of each function from a range of above categories including examples are available through Help (?) on the Ribbon. The quickest way to get help on a function whose name (e.g. SUMIF) when we entered on formula bar followed by equal to sign then double-click the function’s name that appears in the strip. 

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. Which of the following is the conventional method of collecting water?General Aptitude Test · General Knowledge
  2. Select the wrongly spelt word.English · Spelling Check
  3. Arrange the approaches of Human Geography in the chronological order. (A) Areal differentiation(B) Regional Analysis(C) Spatial Organisatio…Geography · Fundamentals of Human Geography: Human Geography-Nature and Scope
  4. Identify the INCORRECT pair with respect to the substances and their specific heat capacity (J kg-1K-1) at room temperature and atmospheric…General Aptitude Test · General Knowledge
  5. Assertion: Article 28 prohibits religious instructions in any educational institution in India. Reasoning:State recognized or State aided e…Legal Studies · Human Rights in India
  6. Select the most appropriate meaning of the underlined idiom in the given sentence. A child in an art museum is like a bull in a China shop.English · Grammar: Idioms
  7. Identify the correct enzyme to release the DNA from the fungal cells?Biology · Biotechnology -Principles and Processes
  8. When the moon is at its farthest distance from Earth, it is called as?General Aptitude Test · General Knowledge
  9. Which of the following is a pair of homonyms?English · Homonyms
  10. The term ‘Bell of Arms’ was used forGeneral Aptitude Test · General Knowledge