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

Which of these is not an argument of the IF function?

Which of these is not an argument of the IF function?

Answer & explanation+

Correct answer: option 3

The correct answer is Option (3) → Value_when_false

The IF function takes three arguments: logical_test, value_if_true and value_if_false. It checks the logical test and returns the first value if the test is true and the second if it is false.

The recognised argument is “value_if_false”. Option (3) swaps if for when, so no such argument exists, and it is the odd one out. One small word changed and a real name turned fake, so read each function name letter by letter.

NCERT (2026-27 edition):
IF Function

Extract from the NCERT textbook

Extract from the NCERT textbook

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 river runs through the city of Sambalpur?English · Comprehension - (Narrative / Factual)
  2. Match List-I with List-IIList-IList-II(A) ion or molecule having two different donor atoms and either of the two ligates in the complex(I)…Chemistry · Inorganic: Coordination Compounds
  3. How many 5-digit numbers can be formed by using digits 1, 2, 3, 4, 5 if 2 and 3 cannot come together?General Aptitude Test · Quantitative Reasoning
  4. Which of the following are the characteristic properties of the manganate ion (MnO42−)?(A) Tetrahedral geometry(B) Purple color(C) Diamagne…Chemistry · Inorganic: D and F Block Elements
  5. Which among the following statements are correct about coalitions after 1967?A. Largely, coalition partners were ideologically incongruent.…Political Science · Politics in India Since Independence: Challenges to and Restoration of the Congress System
  6. The following is not a type of standing plan:Business Studies · Planning
  7. Time series helps to(A) derive conclusions after arranging the time series in a systematic manner.(B) predict the future behavior of a vari…Applied Maths. Section B2 · Time Based Data
  8. In which state has the project "Banksakhi" been launched by Bank of Maharashtra (BOM)?General Aptitude Test · Current Affairs
  9. For what value of μ , […] is a singular matrix?Applied Maths. Section B2 · Algebra
  10. Which one of the following processes is used to identify the recombinant colonies?Biology · Biotechnology -Principles and Processes