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

______ is the function which adds the cells as per given specified cr…

______ is the function which adds the cells as per given specified criteria.

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → SUMIF

SUMIF adds only those cells in a range that meet a condition, written as SUMIF(range, criteria, sum_range). IF only tests a condition and returns one of two values, and COUNTIF counts the cells meeting a condition instead of adding them. There is no function called WHATIF; what-if analysis is a separate set of tools.

NCERT (2026-27 edition):
Mathematical Function – “… 1. SUMIF is the function which adds the cells as per given specified criteria the syntax of this is as follows: SUMIF (range, criteria, sum_range) where Range it is the range of cells to evaluate.”

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. In the year 2001, China became a part of which organization?Political Science · Contemporary World Politics: Contemporary Centres of power
  2. A man completes 30 km of a journey at 6 km/h and the remaining 40 km of the journey in 5 h. His average speed for the whole journey isGeneral Aptitude Test · Numerical Ability
  3. The minimum value of α , where α = 4/(sin x)+1/(1-sinx), isApplied Maths. Section B2 · Calculus
  4. This Painting belongs to which mythological book?Fine Arts · The Rajasthani Schools of Painting
  5. On Tanvi's list is one of the most important descriptions of the city of Vijayanagara in the fifteenth century. In what role had its author…History · Medieval India: Through the Eyes of Travellers
  6. Rearrange the sentences to make a paragraph - A. Now divided into two separate states of India and Pakistan,B. The population of India as a…English · Arrange in Meaningful Sequence
  7. Which of the following relation represents correct relationship of osmotic pressure with concentration of the solution?Chemistry · Physical: Solutions
  8. Which of the following countries, though poor in natural resources, became developed by investing in its human resource?General Aptitude Test · General Knowledge
  9. What is empirical relationship between mean, median and mode?A. Mean - Mode = 3(Mean - Median)B. Mode = Mean - MedianC. Mode = 3 Median - 2…General Aptitude Test · Numerical Ability
  10. Trends of modernization in India is visible through the following:Sociology · Social Change and Development in India: Cultural Change