4.0 Introduction
4.1 Objectives
4.2 Elements of Spread Sheet
4.2.1 Creating of Spread Sheet
4.2.2 Concept of Cell Address [Row and Column]
and selecting a Cell
4.2.3 Entering Data [text, number, date] in Cells
4.2.4 Page Setup
4.2.5 Printing of Sheet
4.2.6 Saving Spreadsheet
4.2.7 Opening and Closing
4.3 Manipulation of Cells & Sheet
4.3.1 Modifying / Editing Cell Content
4.3.2 Formatting Cell (Font, Alignment, Style )
4.3.3 Cut, Copy, Paste & Paste Special
4.3.4 Changing Cell Height and Width
4.3.5 Inserting and Deleting Rows, Column
4.3.6 AutoFill
4.3.7 Sorting & Filtering
4.3.8 Freezing panes
4.4 Formulas, Functions and Charts
4.4.1 Using Formulas for Numbers (Addition,
Subtraction, Multiplication & Division)
4.4.2 AutoSum
4.4.3 Functions (Sum, Count, MAX, MIN, AVERAGE)
4.4.4 Charts (Bar, Pie, Line)
4.5 Summary
4.6 Model Questions and Answers
After completion of this chapter, candidate will have good hands- on practice on Basic Knowledge of Spreadsheet Processing, their usage, details of Spreadsheet screen. Opening, savingand printing a Spreadsheet. Spreadsheet creation, inserting and editing data in cells, sorting and filtering of data. Inserting and deleting rows /columns. Applying basic formulas and functions. Prepare chart to represent the information in a pictorial form.