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 formula would result in TRUE if C4 is less than 10 and D4 is le…

Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → =AND(C4<10, D4<100).

The AND function returns TRUE only when every condition in it is TRUE, and FALSE if even one is FALSE. So the formula must test both conditions of the question, “C4 is less than 10” and “D4 is less than 100”, with the right cells and the < sign: =AND(C4<10, D4<100).

Why the other options are incorrect

  • Option (1) =AND(C4>10, D4>10). — Incorrect. Both signs are reversed and the limit for D4 is wrong; it tests for C4 and D4 greater than 10.

  • Option (2) =AND(C4>10, C4<100). — Incorrect. It tests only C4, for a value between 10 and 100, and never looks at D4.

  • Option (3) =AND(C4>10, D4<10). — Incorrect. The sign for C4 is reversed and D4 is compared with 10 instead of 100.

NCERT (2026-27 edition):
Exercises

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. Identify the plantation crops from the following. A. CoffeeB. RubberC. WheatD. Cocoa Choose the correct answer from the options given below:Geography · Fundamentals of Human Geography: Primary Activities
  2. Match List-I with List-II List-IList-II(A) 1947(I) Last meeting of the Interim Government(B) 1949(II) Cabinet Mission Scheme is presented(C…History · Modern India: Framing the Constitution
  3. While doing revaluation of assets in case of admission of partner, there is a statement" All debtors are good". What does it mean?Accountancy Part A · Admission of a Partner
  4. Identify the figure of speech in the underlined part of the sentence:From the window of our slow train to Darjeeling, we watched tea-picker…English · Figure of Speech
  5. Which of the following is NOT correct about the average product (AP) and marginal product (MP) of an input?Economics · Micro Economics: Production and Costs
  6. Consumption habits is a major element of ___________ environment.Business Studies · Business Environment
  7. Select the most appropriate meaning of the given idiom. To burn one's boatEnglish · Grammar: Idioms
  8. Two events A and B are independent, if A. A and B are mutually exclusive. B. P≤ft(A' ∩ B')=[1-P(A)][1-P(B)] C. P≤ft(A')=P≤ft(B') D. P(A)+P(…Maths. Section A · Probability (Section A)
  9. Choose the correct plural form of the word given below:AlgaEnglish · Grammar: Singular/Plural
  10. Which of the following is a homogeneous differential equations ?Applied Maths. Section B2 · Calculus