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 CGraphs and Charts for Business Data

To create a chart in Excel, the sequence to be followed is: A. Add su…

To create a chart in Excel, the sequence to be followed is:

A. Add sub chart/graph (if needed)
B. Totalling of rows and columns
C. Selection of chart type from ribbon
D. Enter the data
E. Formatting of chart

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 2

The correct answer is Option (2) → D, B, C, A, E

(D) Enter the data – the data are entered in a worksheet with row and column titles.

(B) Totalling of rows and columns – row and column totals are worked out in the worksheet.

(C) Selection of chart type from ribbon – the chart is created by choosing its type from the Insert tab.

(A) Add sub chart/graph (if needed) – sub-types or a combination chart are added to the basic chart.

(E) Formatting of chart – finally the layout, style and format of the chart elements are changed.

NCERT (2026-27 edition):
Following are the steps prepare a chart

Extract from the NCERT textbook

NCERT (2026-27 edition):
Step - 1 – “… The row totals (row number 11) gives the quarter wise total sales of products and the column totals (column number G) gives product wise total sales.”

NCERT (2026-27 edition):
Basics Steps for Graphs/Charts/Diagrams using Excel – “… We can also create a combination of chart by using more than one chart type in any chart.”

Advertisement

Practise more on Graphs and Charts for Business Data

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 are the three parts of bacterial flagellum?General Aptitude Test · General Knowledge
  2. The absolute maximum value of the function f(x) = 4x - 1/2x^2 in the interval [-2, 9/2] is:Maths. Section B1 · Applications of Derivatives
  3. तत्पुरुष समास का उदाहरण है -Hindi · व्याकरण - ससमास
  4. Which instrument was used to detect gravitational waves for the very first time?General Aptitude Test · General Knowledge
  5. Which of the following would appropriately define a budget set?Economics · Micro Economics: Theory of Consumer behaviour
  6. 'The Lucknow Pact' was an understanding between the Indian National Congress and the Muslim League on:History · Modern India: Understanding Partition
  7. The function f: R → [-1, 1] defined by f(x) = cos x is:Maths. Section B1 · Relations and Functions
  8. Which of the is NOT a geographical factor influencing distribution of population ?Geography · Fundamentals of Human Geography: World Population-Distribution, Density and growth
  9. Select the most appropriate ANTONYM of the given word. SagaciousEnglish · Antonyms
  10. Which of the following is NOT a common feature of projective techniques used for assessing personality?Psychology · Self and Personality