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

Match List-I with List-IIList-IList-II(A)It is the function which add…

Match List-I with List-II

List-IList-II
(A)It is the function which adds the cells as per given specified criteria(I)ROUND
(B)It is the function to rounds a number to specified number of digits.(II)CONCATENATE
(C)It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.(III)SUMIF
(D)This function joins two or more text strings into one text string(IV)COUNT

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 3

The correct answer is Option (3) → (A) - (III), (B) - (I), (C) - (IV), (D) - (II)

Each description in List-I is what one spreadsheet function does; the name of the function usually says it.

(A) It is the function which adds the cells as per given specified criteria — this matches (III) SUMIF. It adds only the cells that meet a condition, for example the depreciation of assets whose value is above a given figure.

(B) It is the function to rounds a number to specified number of digits. — this matches (I) ROUND. It takes a number and the number of digits to round it to.

(C) It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers. — this matches (IV) COUNT. It counts how many cells hold numbers or dates, ignoring text and empty cells.

(D) This function joins two or more text strings into one text string — this matches (II) CONCATENATE. For example, it joins first name, middle name and surname into a full name.

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: … 2. ROUND is the function to rounds a number to specified number of digits. … 3. COUNT This function counts the number of cells that contain numbers and counts numbers within the list of arguments. COUNT is use to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.”

NCERT (2026-27 edition):
Text Manipulation Function – “… This function joins two or more text strings into one text string and its syntax is : CONCATENATE (text1, text2,...) where text1, text2, … are 2 to 255 text items to be joined into a single text item.”

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. Arrange the current drawn by the following appliances, that operate in a house having a 220 V supply line, in ascending order(A) 760 W elec…Physics · Current Electricity
  2. A metallic resistor R is connected across a battery of emf E . In the resistor, a number of collisions of the free electrons with the latti…Physics · Current Electricity
  3. Which statement given below is not true for the reaction ?Fe3+ + e− → Fe2+Chemistry · Physical: Electro Chemistry
  4. Match the LIST-I with LIST-IILIST-ILIST-IITermsRelationshipsA. Divergent evolutionI. Hugo deVriesB. MutationII. Charles DarwinC. Natural se…Biology · Evolution
  5. The order of liquidating current assets is:(A) Prepaid Expenses(B) Finished goods inventory(C) Raw Material(D) Cash at BankChoose the corre…Business Studies · Financial Management
  6. The passage states that the miniature paintings during the reign of Umed Singh served as flattering records of the hunting games and the ki…English · Comprehension - (Narrative / Factual)
  7. The protective function of SEBI is:Business Studies · Financial Markets
  8. What is the function of the insulin hormone?General Aptitude Test · General Knowledge
  9. Inversion or hydrolysis of cane sugar (in presence of excess of water) i.e.C12H22O11 + H2O → C6H12O6 + C6H12O6Cane Sugar Glucose Fructoseis…Chemistry · Physical: Chemical Kinetics
  10. Financial statements are:Accountancy Part B · Financial Statements of a Company