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 function results can be displayed in Auto Calculate?

Which function results can be displayed in Auto Calculate?

Answer & explanation+

Correct answer: option 1

The correct answer is Option (1) → SUM and AVERAGE

AutoCalculate shows a quick result for the cells selected in the worksheet, on the status bar, without a formula being typed into a cell. SUM and AVERAGE are functions whose results it displays. LOOK, LABEL and BLANK are not functions whose results AutoCalculate shows, so Options (2), (3) and (4) each include one that it cannot display.

NCERT (2026-27 edition):
Multiple Choice Questions

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. A copper coil is placed with its axis horizontally from left to right. The N pole of a bar magnet is moved towards the coil parallel to its…Physics · Electromagnetic Induction
  2. Match List-I with List-IIList-IList-IIOrder and DegreeDifferential Equations(A) order=2, degree=1(I) ≤ft((d^2y)/(dx^2))^3+e^x=x (B) order=2…Maths. Section A · Differential Equations (Section A)
  3. An electromagnetic wave of frequency 10 MHz, propagating in a medium, has the magnitude of its propagation vector 0.5 m−1. The refractive i…Physics · Electromagnetic Waves
  4. A pair of dice is thrown then probability of getting sum of numbers on dice is ‘8’, is:Maths. Section A · Probability
  5. It is mandatory to settle all stock market trades as per settlement cycle on _____________ on a rolling settlement basis.Business Studies · Financial Markets
  6. In the Faraday experiment, North-pole of a bar magnet is being pushed towards the closed coil. The induced current in the coilPhysics · Electromagnetic Induction
  7. In the 1920s, the Indian National Congress was reorganised on the basis of:Sociology · Indian Society: Challenges of Cultural Diversity
  8. The work done in moving a unit charge from one point to another point by an electric field is known as:Physics · Electrostatic Potential and Capacitance
  9. A long solenoid is formed by winding 20 turns cm−1. The current which is necessary to produce a magnetic field of 20 mT inside the solenoid…Physics · Moving Charges and Magnetism
  10. Match the words given in List-I with their synonyms in List-II:-List-IWordsList-IISynonyms(A) Somber(I) Concise(B) Clandestine(II) Destroye…English · Synonyms