ICT_Unit_IV_Dr_NS_Part_2.pptx

Spreadsheet

1. Introducing Spreadsheet

2. Content Introduction to Spreadsheet Worksheet Window Rows & Columns Cell, Active cell & Pointer Cell address Range Cell entry & values Formula

3. Introduction to Spreadsheet  Spreadsheet applications a re co m p u t er p r og r a m s t h a t enab l e u s t o c r ea te spreadsheet.  I t all o w s u s t o a na l y z e an d o rg an iz e da ta into tables.  I t i s u s e t o m ak e s i m p l e a n d co m p l e x calculations.

4. Worksheet  The area where we enter the data is called worksheet.

5. Window co nt a i n s  Worksheet co l u m ns , s o m an y w e c a nno t r o w s an d t he en t ire spreadsheet on the screen.  T h e po r t i o n o f w or ksh e e t t h a t w e se e is called window.

6. Rows & Columns  Rows are horizontal division of worksheet.  Each row is indicated by numbers.  Columns are vertical division of worksheet.  Each column is indicated by letter.

7. These are columns These are rows

8. Cell A cell is the area where a row and column meet.

9.  A cell on which we click is called Active cell.  An active cell has a highlighted cell boundary called a cell pointer.  We refer a cell by its address. The cell address consists of column letter and row number. E.g A5

10. Range  R an ge r e f e rs to a group of cell.  We r a n g e b y i d e n ti f y ad dr e ss o f t h e f i r st ce ll and last cell.

11. Cell Entry  Data inserted in a cell is called cell entry.  A cell entry may consist of data such as words, number, or formula.  Numbers entered in a cell are called values.

12.  There are 3 main types of values that can be entered into a cell Numbers Text F or m ulas

13. F o r mula  A formula performs calculations using values from other cells.  We can apply formula for a range of values.

14.  When a formula is entered into a cell, it must begin with the equal (=) sign.

15. Graph  We can insert chart or graph in a worksheet to present numerical data in visual form.  V a r i ou s t o o l ar e a v a il a bl e i n t h e ch arts group on the insert tab.