✓ Board-verified
Accountancy · 2025 · 4 marks
Graphs and Charts for Business DataBasics Steps for Graphs/Charts/Diagrams Using Excel4 marksshort answer
CBSE 2025 · Region 5 · Set 1 · Q33
State the steps to prepare a chart.ORWhat is meant by internal margin while using MS Excel ? State the options available.
OR
What is meant by internal margin while using MS Excel ? State the options available.Marking-scheme solution
Following are the steps to prepare a chart:
1. Enter data in a worksheet with proper column and row titles.
2. Create a basic chart using the pattern from the panel available on top of worksheet in chart groups'
options.
3. Change layout or style of chart
• Apply predefined chart layout.
• Apply pre-defined chart style.
• Change the layout of chart element.
• Change format of chart.
4. Add or remove titles or data labels.
• Add (Remove) a chart title.
• Add (Remove) axis title.
• Link a title to worksheet cell.
• Add-remove data labels.
5. Show or hide a legend.
6. Display or hide chart axes or gridlines.
• Display (hide) primary axes
• Display (hide) secondary axes
• Display (hide) gridlines
7. Move (resize) a chart.
8. Save a chart.
OR
Q.(b) What is meant by internal………………………………..
Ans. The internal margin is the distance between the text and the outer border of the element and that
this distance can be adjusted using the following options:
• Left: To specify the distance between the left border of the selected chart element and the text, enter
the desired margin number in the left box.
• Right: Similar can be done for right side.
•For Top and Bottom, enter the desired numbers in the respective boxes and the desired distance can
be achieved.More from Graphs and Charts for Business Data
- To see all available shape styles which of the following button is clicked. 'P2025
- From the following a legend can be repositioned on a chart: OR Which of the following are the five pillars of…2023
- A piece of information shown in a graph which is assigned to the data series is known as: OR Identify the…2025
- 'A piece of information shown in a graph which is assigned to the data series' is known as: OR 'LABELS in…2024
- Which chart element details the data values and categories below the chart:2026
- To see all available shape styles which of the following button is clicked?2025
- In a graph, the area bounded by different axes is known as:2025
- Write the advantages of using Graphs.2025
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.