9th Class Computers Science Microsoft Excel Introducing Spreadsheet

  Introducing Spreadsheet

Worksheet environment which is used to manage numbers and calculation or provides an electronic worksheet is known as Excel. An Excel file, which contains several worksheets, is referred as a workbook. The text, numbers and formulas which enters in Excel is permitted by Worksheet. By default three worksheets are presented in every workbook. It promotes number of features that allows you to generate formulas which are automatically updated when you change plot numeric data and data in charts. It contains grid which is made up of columns and rows, thus it is used easily to perform mathematical calculations.  

 Applications related to worksheets are the following: 

• Financial accounting.
• Helps in solving complex engineering problems.
• Helps in inventory controls and formatting reports.
• Helps in creating business planning.
• Helps in preparing Invoice.

Rows and Columns are the main component of worksheets. A column and rows are the vertical and horizontal group of cells. Maximum numbers of columns you can enter in an Excel worksheet are 256. Whereas the maximum number of rows you can enter in that are 65,536 rows.  

  Basically there are five types of spreadsheets: 

• Arithmetic Spreadsheets: Enables number of arithmetic functions, such as sum, and average that help in arithmetic calculations.
• Two-Dimensional Spreadsheets: Arranges data in rows and columns like a table.
• Three - Dimensional Spreadsheet: Enables more than one two-dimensional sheet that stacks related spreadsheets on top of each Other.
• Logical Spreadsheet: Enables logic functions rather than arithmetic functions that are used in deductive reasoning.
• Object-Oriented Spreadsheets: Allows viewing, analyzing and mapping data in different ways/This type of spreadsheet is; organized by objects rather than using two dimensional cells.