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

What is the purpose of data validation in Excel?

What is the purpose of data validation in Excel?

Answer & explanation+

Correct answer: option 2

The correct answer is option 2- To define restrictions on the type of data entered into a cell.

Data validation is a feature to define restrictions on type of data entered into a cell. We can configure data validation rules for cells data that will not allow users to enter invalid data, There may be warning messages when users tries to type wrong data in the cell. The messages also guide users to what input is expected for the cell, and instructions to correct any errors.

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. Assertion: Indian merchants and middlemen supplied and participated in the trade of opium and they helped integrate Bombay's economy direct…History · Modern India: Colonial cities
  2. Myopia disease is connected with:General Aptitude Test · General Knowledge
  3. Arrange the following in a chronological order: A. Abd-al RazzaqB. Al-BiruniC. Ibn BattutaD. Francois BernierE. Marco Polo Choose the corre…History · Medieval India: Through the Eyes of Travellers
  4. Where is the Rumi Darwaza located?General Aptitude Test · General Knowledge
  5. Select the option in which the words share the same relationship as that shared by the given pair of words. Blunder : ErrorGeneral Aptitude Test · General Ability
  6. Social movement is:Sociology · Social Change and Development in India: Social Movements
  7. Rearrange the following parts to form a meaningful sentence:(A) though he shares quite a few with the squirrels(B) Ever since Grandfather p…English · Arrange in Meaningful Sequence
  8. Guru Arjan, the fifth preceptor, compiled the Adi Granth Sahib. Leaving out other religious poets, the hymns of how many Sikh gurus did it…History · Medieval India: Bhakti Sufi Traditions
  9. Choose the correct relation between focal length f and radius of curvature R of a convex mirror from the following:Physics · Ray Optics
  10. Which of the following statement (s) is/are NOT correct in respect of Natural Gas reserves in India?Geography · India-People and Economy: Mineral and Energy resources