Information and Communication Technology

5.4.1 Introduction

• It is used to create and perform "What If" analysis of complex, interrelated columnar reports.
• Easy to manipulate data in grid format
• Formulas can be applied and copied to other areas easily.
• Function wizard is used to apply formulas easily to the cells. Complex problems can be solved using function wizard.
• A chart Wizard helps to convert cell data into pie charts, line graphs, bar charts, three-dimensional charts, scatter charts and other visual aids.
• Data can be summarized using subtotal, pivot table, filter, consolidate etc.
• Any part of worksheet can be viewed, modified and printed