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 is used to remove spaces before and after the text?

Which function is used to remove spaces before and after the text?

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → TRIM

The TRIM function cleans an entry by removing the extra spaces before and after the text, so that data typed with stray spaces still matches. In data validation it is used to stop a user from entering spaces before or after the text.

NCERT (2026-27 edition):
Data Validation – “We can prevent user from adding … spaces before or after the text in entry. The TRIM function removes spaces before and after the text.”

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. What is the basis of creation of the new states of Chattisgarh, Uttarakhand and Jharkhand?Sociology · Indian Society: Challenges of Cultural Diversity
  2. Addison's disease is not characterised byChemistry · Organic: Biomolecules
  3. Choose the correct collective noun from the options below and fill in the blank. A ………… of fish.English · Collective Noun
  4. Let O, O' and G be the circumcentre, orthocentre and centroid of a ΔABC and S be any point in the plane of the triangle. Statement-1: O'A+O…Maths. Section B1 · Vectors
  5. Light of wavelength 310 nm falls on a metal surface, and the photoelectrons emitted have a maximum kinetic energy of 1.5 eV. The threshold…Physics · Dual Nature of Radiation and Matter
  6. Which of the following is radioactive in nature?Chemistry · Inorganic: P Block Elements
  7. Which of the following shows modernization to increase the production of goods and services?General Aptitude Test · General Knowledge
  8. Chemistry · Inorganic: Coordination Compounds
  9. Due to fall in manpower, the production in a company decreases by 35%. By what percentage should the working hours be increased to restore…General Aptitude Test · Numerical Ability
  10. In which year was NABARD established?General Aptitude Test · General Knowledge