tech.

• Title bar

  This displays the name of the program, as well as the name of the current workbook if it has been saved. If the workbook has not been saved, it is identified by a number; for example, 'Book1')
• Ribbon tabs

  These are usually found at the top of a worksheet and have key words that represent a group of closely-related commands.
• Vertical and horizontal scroll bars

  These are used to scroll the workbook window vertically and horizontally through a worksheet.
• Worksheet tabs

  These identify the various worksheets in a workbook, and allow you to move from one worksheet to another.

  Worksheets are therefore sub-parts of workbooks.
• Status bar

  This displays helpful information as you use the program. The 'Ready' indicator that currently appears lets you know that the program is ready for data input.
• Name box

  This identifies the active cell.
• Formula bar

  This displays the contents of the active cell, if any.
• Workbook window

  This window, which occupies the majority of the screen, displays an Excel workbook.
• A cell can contain one of three types of information: label (text), value (number) or formula.
• A label can be used as a title or heading to describe an aspect of the worksheet. Although a label can contain any string of characters (letters or numbers), it must start with a character that does not indicate a formula or number. A label cannot be used in a calculation.
• A value is a piece of data that can be used in a calculation.
• A formula is an instruction to perform operations on values.

  Depending on the package you are using, a formula must start

  with one of these special symbols: +, -, @, = to identify it as a

  formula. All formulae in Excel start with an equal sign (=).
• A spreadsheet is an electronic worksheet used to manipulate and  organize numbers. 

  A workbook is a collection of related spreadsheets. It is made up of  cells. There is a cell at the intersection of each row and column which  can contain a value. 
• A worksheet is a single spreadsheet in a workbook (like a page in a  book). The maximum number of sheets in a workbook is 16. The  worksheet is made up of horizontal rows and vertical columns. 
• row, cell, column

  
• Rows in a worksheet are given a numeric value such as 1, 2,3 etc…

  • Columns in a worksheet are given are given letters of the alphabet  such as A, B, C etc… 

  • Each cell in the spreadsheet is referenced by its cell address.  
•  A spreadsheet application may be used for a variety of tasks including: – Preparing payroll 

  – Financial statements 

  • Trial balance 

  • Profit and loss 

  • Balance sheet 

  • Statement of income and expenditure 

  • Charts, graphs 

  • budgeting 
•  Formatting – using a value in a spreadsheet that can be displayed in a  user defined form. 
• Formula – refers to data that can be manipulated by either user  created formula or predefined functions. 
•  Graphics – most spreadsheet packages have built in tools that allow  the user to create charts of varying types. 
• Consolidated features – data from several worksheets may be  combined into one large worksheet. 
•  A text entry is used to label or explain the contents of the workbook.  • Labels are aligned to the left of the cell and cannot be used in  calculations. Labels can be formatted so that they are either left, right  or center justified. 

  • Values are aligned to the right and are used in calculations. Values can  be formatted to display : 

  – Dollar sign ($) 

  – Decimal place (21.36) 

  – Percentage sign (%) 
• Parts of a spreadsheet

  
• parts of a spreadsheet 2