| Class XII |
Accountancy |
Computerised Accounting System |
3 |
Which of these is not an argument of the IF function? a. Logical_test. b. Value_if_false. c. Value_when_false. d. Value_if_true. 7. In what cell is... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
3 |
class of 25 student’s month wise for 10 months. Calculate the percentage of presence for each student every month. Prepare a month wise summary of ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
G RAPHS AND C HARTS F OR B USINESS DATA Learning Objectives Introduction able to:udying this chapter, you wiIn the previous chapter, you were intro... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
mouse click on Start Icon 2. On clicking of Start symbol we will get Programs option; which will provide us access to a list of programs installed ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
the given data by Excel the above steps are essential and important. From the 107 tab on the ribbon we can see that Excel supports many Reprint 202... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
are called data markers. Data markers of the same colour constitute a data series. The data series are related data points that are plotted in the ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
the look of a chart. In the Design dialog box, we can click to change chart type, chart layouts and chart styles. One of the options provide for 2-... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
the shape style box, click the style that we want. Figure 4.8 (e) • To apply a different shape fill, click Shape Fill, and then do one of the follo... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
the text to be changed, or do the following to select the chart element from a list of chart elements: 2. Click anywhere in the chart. 3. This disp... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
to Pie chart because Figure 4.9 Reprint 2026-27 Computerised Accounting System • Only one data series is used to plot. • The plotted data values ar... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
that you want, or type a value between 0 (zero) and 360 to specify the angle of the first slice to appear, and then click Close. 17.Click the chart... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
we have to present negative values also, which can be put on the opposite side of the axes from origin (Figure 4.10). The intersection of both the ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
Product Lowest Highest (Y-axis). Toothpaste 2345 12344 2. Horizontal (category) axis – Toothbrush 500 5415 (X-axis). 3. Depth (series) axis – (Z-ax... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
value to a total while emphasising individual values, but they can contain more than one data series. 4.3 ADVANTAGES IN USING Figure 4.13 GRAPH/CHA... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
charts are used to depict the comparison of absolute values of data (e.g. sales, production, etc.) at discrete points (e.g. time intervals, product... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
option. Step – 3: Change the layout or style of chart. Apply a predefined chart layout. Apply a predefined chart style. Change the layout of chart ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
and b. 120 d. None of the above. Reprint 2026-27 Graphs and Charts for Business Data 7. Doughnut charts: a. Contains more than one data series. b. ... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
chart. 3. Describe about data series, legend, and data labels?? 4. Describe use of Excel for preparation of chart. 5. Differentiate between pie cha... |
|
| Class XII |
Accountancy |
Computerised Accounting System |
4 |
180 350 232 125 1000 Students Reprint 2026-27 Computerised Accounting System A NSWERS 1. d 2. d 3. a 4. b 5. c 6. c 7. c 8. c 9. c 10. a 11. b 12. ... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
Accounting Ratios 5 inancial statements aim at providing financial F information about a business enterprise to meet the information needs of the d... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
10% × 100 of the 1,00,000 ‘Revenue from Operations’. This ratio is termed as gross profit ratio. Similarly, inventory turnover ratio may be 6 which... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
To provide information for making cross-sectional analysis by comparing the performance with the best industry standards; and 5. To provide informa... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
very useful feature. 4. Identification of problem areas: Ratios help business in identifying the problem areas as well as the bright areas of the b... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
advanced money to the business on long-term basis are interested in safety of their periodic payment of interest as well as the Reprint 2026-27 Acc... |
|
| Class XII |
Accountancy |
Accountancy Part-II |
5 |
application of accounting policies. The soundness of the judgement necessarily depends on the competence and integrity of those who make them and o... |
|