Page 290 - Computer - 9(A&B)
P. 290

Pooja            87             98              76

                       Teena            67             87              89
                       Rohit            98             45              98
                  Insert two new columns  before ‘Total  Marks’  column  and name  them as Science  and Computer
                     Science. Add suitable data in the cells.
                  Calculate total marks and percentage obtained by each student.
                  Insert two rows and enter data in them.

                  Change the percentage so that it displays two places of decimal.
              v Create a worksheet as shown.











                  Create a Bar chart for the data shown.
                  Format the chart as per the following instructions.
                     •   Change the border and color of plot area.
                     •   Format the Data series, X-axis and Y-axis.
                     •   Format the legend.
















                                                                                                   Observational Skills
                                                           Fun Time                                Observational Skills
                                                           Fun Time
              v Look at the following worksheet.

















                  a.  Identify the cell reference of cell D2.
                  b.  Which function helps to fi nd the maximum simple interest?
                  c.  Identify the chart type.
                  d.  Write the formula to fi nd the difference between maximum and minimum simple interest.


               152
               152
   285   286   287   288   289   290   291   292   293   294   295