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 used to build single formulas that produce multi…

................. is used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns.

Answer & explanation+

Correct answer: option 1

The correct answer is option 1- Array.

Array is used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns.

Array is Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.
Array formula- A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.

 

OTHER OPTIONS

  • COUNT 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.
  • ROUND is the function to rounds a number to specified number of digits.

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 India, which of the following is NOT a factor responsible for reduction of birth rate in the 21st century?Geography · India-People and Economy: Population-Distribution,Density, Growth and Composition
  2. How the intensity of central maximum vary with the slit width?Physics · Wave Optics
  3. In microeconomics, the individual ‘economic agents’ include:Economics · Macro Economics: Introduction
  4. Among the various formats of business plan which one is used by Raghu.Entrepreneurship · Entrepreneurial Opportunity
  5. If a, b, c are the pth, qth and rth terms of a G.P., then the angle between the vector vec u =(log a) hat i + (log b)hat j + (log c)hat k a…Maths. Section B1 · Vectors
  6. If (x + 10)% of 200 is 331/3% more than x% of 180, then 10% of (x + 20) is what percent less than 40% of x?General Aptitude Test · Numerical Ability
  7. Which of the following mirrors is commonly used in torches and vehicle headlights?General Aptitude Test · General Knowledge
  8. In 90 liters mixture of milk and water, the ratio of the amount of milk to that of the amount of water is 5 ∶ 4. In order to make this rati…General Aptitude Test · Numerical Ability
  9. Which one of the following states is the leading producer of gold?General Aptitude Test · General Knowledge
  10. Select the correct option that indicates the arrangement of the given words in the order in which they appear in an English dictionary. 1.…General Aptitude Test · Verbal Reasoning