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

#NUM! Error - When does this error occurs in excel spreadsheet?

#NUM! Error - When does this error occurs in excel spreadsheet?

Answer & explanation+

Correct answer: option 2

The correct answer is Option (2) → This error occurs with invalid numeric values in a formula or function.

Excel shows #NUM! when a formula or function gets a number it cannot work with, for example an argument that must be numeric is given something unacceptable, or a result is too large or too small to show. The other options describe different errors: an invalid cell reference gives #REF!, a value not available gives #N/A, and division by zero gives #DIV/0!.

NCERT (2026-27 edition):
#NUM! Error – “This error occurs with invalid numeric values in a formula or 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. The moment of the force, F = 4 i + 5 j - 6 k at (2, 0, –3), about the point (2, –2, –2), is given by :Physics · System of Particle and Rotational Motion
  2. The product of two numbers is 4896. If the HCF of the numbers is 36, then their LCM is?General Aptitude Test · Numerical Ability
  3. Select the correct Active/Passive form of the given sentence. Kapil proudly said to his son, “Indian cricket team won the World Cup twice i…English · Grammar: Active Passive Voice
  4. In a class, there are 29 boys and 21 girls. The average score of boys in Maths is 89, whereas the average score of girls in maths is 91. Wh…General Aptitude Test · Numerical Ability
  5. Maths. Section B1 · Relations and Functions
  6. The ratio of milk and water in mixtures of four container are 5:3, 2:1, 3:2 and 7: 4 respectively. In which container is the quantity of mi…General Aptitude Test · Numerical Ability
  7. A particle moves along a straight line OX. At a time t (in seconds) the distance x (in metres) of the particle from O is given by x = 40 +…Physics · Laws of Motion
  8. Faraday's law in integral form is(The symbols have their usual meaning)Physics · Electromagnetic Induction
  9. पत्र की किस दिशा में सम्बोधन लिखते हैं?Hindi · पत्र लेखन
  10. According to the passage, how did Aryabhata explain the nightly movement of the stars from east to west?English · Comprehension - (Narrative / Factual)