✓ Board-verified
Accountancy · 2024 · 4 marks
CBSE 2024 · Region 5 · Set 1 · Q33
List the points of nomenclature used in Excel for charts/graphs.ORExplain the steps to define 'Print area' using Dialog box.
OR
Explain the steps to define 'Print area' using Dialog box.Marking-scheme solution
The nomenclature used in Excel for charts is as follows:
(i)
The chart area
(ii)
The plot area covering the plot of values in the selected type of chart
(iii)
The data points
(iv)
The Horizontal (Base Values e.g. Category) and Vertical (Derived Values) Axes.
(v)
The legend to specify distinguishing criteria in case of multiple lines pies, bars etc.
(vi)
Chart and Axes Titles
(vii)
Data labels
Q. (b) Explain the steps to define ‘Print area’ using Dialog box.
Ans. By default, Excel prints all data on the current worksheet but for specific formatted print, we
have to define print area from page set up dialog box or print area command from page layout
option of ribbon following are the steps to define Print area using Dialog box option:
(i)
Select the page layout command tab on the ribbon
(ii)
In the page set up group click page set up. The page set up dialog box appears
(iii)
Select the sheet tab
(iv)
In the print area text box type the range of cells you want to print or ( to select the area
§ Click to collapse Dialog
§ Select the desired range of cells
§ Click restore the Dialog.
(v)
Click Ok and the print area is defined
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 2024board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.