*SPREADSHEET PACKAGE (MICROSOFT EXCEL)*

MICROSOFT EXCEL

It is a window based on application package that is used in solving calculation both arithmetic problems and engineering problems. It is on electronic speed sheet. It was produce by ms- Corporation as one of the electronic spreadsheet software.

VERSION OF MICROSOFT EXCEL

·        Lotus 123

·        Quartro pro

·        Valcark

·        Lotus AmiPro

·        Super cark  e.t.c

WAYS OF LOADING OR LAUNCHING MICROSOFT EXCEL INTO MEMORY(RAM)

·        After loading the operating window by booting the system

·        Move your mouse pointer to the start button on the taskbar

·        Click on the start button the taskbar

·        point to the all programs 

·        All the available programs will appear

·        Point microsoft office folder

      A dialogue box will appear

      Select Microsoft office excel

At the last you understand that microsoft logo will be display briefly which process the opening of microsoft excel environment.

BARS IN MICROSOFT EXCEL

·        TITTLE BAR: it is located at the top of the screen that display the name of the program e.g. microsoft Excel e.t.c as well as current filename, minimum, maximum and close button.

3

·      

          MENU BAR: it shows the main Manu of the program which include file, edit, view, insect, format, tools, table, window and help.

·    

           STANDARD TOOLS BAR: it consist of main Menu shortcuts or icon used for performing same task or command with out using the menu those shortcut are, view, open, save, point, preview, copy, cut, paste, e.t.c.

·  
      FORMATTING TOOLS BARS: it consist of icon that is use in editing character of such as bold, size, underline, fount colour, line colour center justify e.t.c.  

        FORMULA; it displays the label and formula of the current cell in use.

·   
         WORKSHEET; it  is an area located directly below the formula by which is made up of rows and columns that intercept to form a cell

·     
           SCROLL BAR; it is used in shifting  the spreadsheet up,down,depending on which side you want  to view

·
           SHEET; it displays a particular spreadsheet page that is still in the same file

·        DRAWING TOOL BAR; its a consist of already made gallery image like wordart,autoshapes,dash lines, fill colour draw e.t.c

·        STATUS BAR; it is D horizontal strip below the word sheet which displays the state at worksheet and work of the system.

·        Task bar.

·                                              COMPONENT OF MS-EXCEL

·        Row

·        Colum

·        Cell

·        Value

·        Label

       1 ROW; horizontal group of cell or line that is in a work sheet that runs from left to right, there are 65,536 rows in the worksheet.

2   COLUMNS; it is a vertical group of cell or line in a worksheet that runs from up to down, there 256 columns in ms-excel

3  CELL; it is the interception of row and colum.it is the small idock of rectangle from by interception.are,new,open,save,print,paint,preview,copy,cut,past e.t.c.

4  LABEL; it is a word or group of words that is used as a caption the identify info. Under it, either by row or column

5 VALUE; the data in a spreadsheet is called the value

AREAS OF APPLICATION

1 BUSINESS ORGANIZATION; it is very important in preparing ledger as an accountant, it is needed (ms-excel) in processing app.

Ledger; it is a book that o

Contains account of money for a business

2 EDUCATIONAL LEVEL; it is used in adding and subtracting minor calculation. It is used in working student result and assessment

3 statistical analysis; it help the statistic in solving the statistical problems like %, average e.t.c.

4 BUDGETING; it is use in planning ahead the expenditure of month or year, and it is also used to plan New Year document.

5 financial purpose; it is used to record a financial status of a company

FUNCTIONS OF MS-EXCEL

·        Statistical function

·        Logical function

·        Financial function

v SATISTICAL FUNCTION: it deals with some minor calculations, like average, minimum, maximum, standard deviations summation e.t.c.

FORMULA FOR CALCULATIONS

EXAMPLE FORMULAS;

v TO CALCULATE  MINIMUM:  type = min (B2:E2) press enter key

v TO CALCULATE MAXIMUM:  type = max (B2:F2)press enter key

v TO CALCULATE COUNT: type= count (B2:F2) press enter key

v STANDARD DEVIATION: type –stdev (B2:F2) press enter key

v MULTIPLICATION: type = B2*G2 press enter key

COMMENT

It is a statement made over a particular cell.

STEP

·        Click in cell your want to enter the comment

·        Go to insert on the menu bar

·        Select comment

·        Remove your cursor and observe that the comment is visible

HOW TO REMOVE COMMENT

·        Click in the cell that has the comment

·        Move to edit menu

·        Move to clear

·        Click on all or comment

CHART

Is a graphic or diagram representation of worksheet data.

TYPES OF CHART

·        COLUMN CHART: this shows variation over a period of time that illustrated comparison between two items.

·        LINE CHERT: this shows straight or change on data over a period of time.

·        PIE CHART: this shows relationship or proportion of part to a whole.

·        AREA CHART: it shows relatives information of value over a period of time

·        BAR CHART: this illustrate devotion between items

·        DOUGHNUT CHART: this is similar to pre chart  but more than data series

·        X-Y CHART: this shows relationship between numeric value in several chart maps.

On my next blog I will explain how to solve Statistical & Logical problem, thanks for coming.