Unit-5: Spreadsheet (INTRODUCTION SPREADSHEET)

Unit-5: Spreadsheet

Session :1

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.  Excel allows users to organize, format and calculate data with formulas using a spreadsheet system.

A spreadsheet provides much more flexibility, speed and accuracy, as compared to a manual expense sheet.

Spreadsheets are used for a variety of tasks, such as

• Maintaining records

• Analysing data

• Creating MIS (Management Information System) reports

• Generating graphs (for pictorial representation of data)

• Doing financial calculations

• Managing inventory (Maintain Billing)

• Budgeting etc.     

How to start ms-excel:-

a) Double Click on a shortcut key of the MS-Excel icon, if available, on the desktop.

OR

b) Click [1] Start → [2] All Programs → [3] Microsoft office → [4] Microsoft Office Excel.

OR

c) Click on Start à Searchàtype EXCEL and hit enter.

Some of the key components of a spreadsheet are:

Worksheet: This is a grid of horizontal rows and vertical columns.

Workbook: A workbook contains one or more worksheets.

Row: A row is a horizontal arrangement of cells. The rows are named by numbers (1, 2, 3, 4…)

 Columns: A column is a vertical arrangement of cells. The columns are named by alphabets (A, B, C… Y, Z, AA, AB, AC… AZ, BA…).

 Cell: A Cell is where the rows and columns intersect. Worksheet is also called an array of cells. A cell may contain text, number, date or a formula. A cell address in a spreadsheet identifies location of the cell. It is a combination of column name and row number of the cell, such as A2 or B16 etc.

Active Cell: This is the cell on which the cursor is currently placed. It is outlined by a dark border. Data is always entered in the active cell.

 Formula Bar: This is located below the Ribbon. It displays the contents of the active cell. It can also be used to enter and edit data.

Scroll Bar: These helps to scroll through the content and body of the worksheet. There are two scroll bars – horizontal and vertical.

Note: - For edit in any cell we use F2 Key.