✓ Board-verified
Accountancy · 2023 · 4 marks
CBSE 2023 · Region 3 · Set 2 · Q33
Define 'Charts' and 'Graphs'. Give their any two uses for business.ORWhich error appears when a negative date or time is used ? How can you correct it ?
OR
Which error appears when a negative date or time is used ? How can you correct it ?Marking-scheme solution
Graph is the pictorial representation of data which has at least $\displaystyle 2$ dimensional
relationships.
Chart is a representation of multiple subgroups of single variable and bar
diagrams depict two or more variables.
Uses of charts and graphs (Any two):
(i)
Helps to explore.
(ii)
Helps to present.
(iii)
Helps to convince.
Q. Which error appears when a negative date or time is used? How can you
correct it?
Ans Correct a ##### error appears when a negative time or date is used in excel.
•
To correct it one must check with the window control panel. The default time
and date format is based on regional date and time setting that are specified
in window control panel and changes when changes are made to those
settings.
•
If one is using $\displaystyle 1900$ date system the date and times in excel must be positive
values.
•
When we subtract dates and times, make sure that we build the formula
correctly.
• If the formula is correct but the result is still a negative value, we can display
the value by formatting the cell with a format that is not a date or time format.
•
On the home tab in the cells group click format, click format cells and then
click number tab.
•
Select a format that is not a date or time format.
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 2023board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.