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 CUse of Spreadsheet in Business Applications

Why If-function is used in spreadsheet?

Why If-function is used in spreadsheet?

Answer & explanation+

Correct answer: option 1

The correct answer is option 1- To implement different action corresponding to different conditions.

Excel has a rich library of various built-in functions including financial functions, which can be directly used to carry out various (otherwise complex) calculations. A formula may use one or more such functions. In applications of excel, some of the formulae use absolute address. The absolute address is used for those cells whose content should not change while the formula containing such cells is copied to other cells. If-function is also used in these applications. If-function is used to implement different action corresponding to different conditions. 

Advertisement

Practise more on Use of Spreadsheet in Business Applications

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 which of the following years was the Rajya Sabha first constituted?General Aptitude Test · General Knowledge
  2. Select the most appropriate synonym of the given word. ABSOLVEDEnglish · Synonyms
  3. A health talk on junk food brought about attitude change in many students, mainly because it was given by a well-known doctor whom they tru…Psychology · Attitudes and Social Cognition
  4. Select the Venn Diagram, the best represents the relationships between the following words. Vertebrates, Non - Vertebrates, Living BeingsGeneral Aptitude Test · Verbal Reasoning
  5. Decennial censuses are conducted after how many years?History · Modern India: Colonial cities
  6. Three different positions of the same dice are shown. Select the number that will be on the face opposite to the face showing the number '1…General Aptitude Test · Verbal Reasoning
  7. If there is an opening bank overdraft, it will be shown in.........Accountancy Part A · Accounts for Non Profit Organsiation
  8. For the given five values 12, 16, 20, 30, k, the three years moving averages are 16, 22, 28, then the value of k is :Applied Maths. Section B2 · Time Based Data
  9. A sum of money is divided among A, B, and C in the ratio 2 : 3 : 7, respectively. If the share of B is ₹15,000, then what will be the diffe…General Aptitude Test · Numerical Ability
  10. A hemispherical paper weight contains a small artificial flower of transverse size 2 mm on its axis of symmetry at a distance of 4 cm from…Physics · Ray Optics