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 CUse of Spreadsheet in Business Applications

Which formula is true if C4 is less than 10 and D4 is less than 100?

Which formula is 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 if all the conditions inside it are TRUE.

The formula to be true when:

  • C4 is less than 10 (C4<10)
  • D4 is less than 100 (D4<100)

Advertisement

Practise more on Use of Spreadsheet in Business Applications

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 is a Development function of SEBI?Business Studies · Financial Markets
  2. In a certain code language, ‘RIP’ is written as ‘42’ and ‘MOL’ is written as ‘39’. What will be the code for ‘GAN’ in that code language?General Aptitude Test · Verbal Reasoning
  3. Match List-I (Monument) with List-II (Present-day state).List-IList-II(A) Kailashnatha Temple(I) Bihar(B) Great Stupa at Sanchi(II) Maharas…History · Ancient India: Thinkers, Beliefs and Buildings
  4. At T(K), for the reaction:H2(g) + I2(g) → 2HI(g), (Δ[HI])/(Δ t) is found to be 2 × 10−4 mol L−1 min−1. What is the average rate of this rea…Chemistry · Physical: Chemical Kinetics
  5. A sold a mobile phone to B at a gain of 25% and B sold it to C at a loss of 10%. If C paid ₹5,625 for it, how much did A pay (in ₹) for the…General Aptitude Test · Numerical Ability
  6. Select the most appropriate word to fill in the blank. She ______ on paying the bill at the restaurant.English · Fill Blanks
  7. When the price of rice is increased by 17%, a family reduced its consumption in such a way that the expenditure on rice is only 5% more tha…General Aptitude Test · Numerical Ability
  8. Which of the following is an advantage of external sources of recruitment?Business Studies · Staffing
  9. "सोच रहे थे, जीवन सुख है, न यह विकट पहेली हैभाग अरे मनु! इन्द्रजाल से इतनी व्यथा न झेली है?"उपर्युक्त पंक्तियों में कौन सा रस है ?Hindi · व्याकरण - रस
  10. Three of the following four number-pairs are alike in a certain way and one is different. Select the one that is different.General Aptitude Test · General Ability