Microsoft Excel

• MICROSOFT EXCEL


  IS A SPREADSHEET PROGRAM THAT ALLOWS USERS TO ORGANIZE, FORMAT, AND CALCULATE DATA IN A SPREADSHEET
• MS EXCEL WORKSHEET

  CONTAINS 1,048,576 ROWS AND 16,384 COLUMNS
• IN ONE WORKBOOK YOU CAN ADD 255 SEPARATE SHEETS.
• PARTS OF MS EXCEL

  A) Name Box

  B) Active Cell Border

  C) Row Numbers in Row Header

  D) Sheet Tab

  E) Add New Sheet Icon

  F) Insert Icon Dialog Box

  G) Formula Bar

  H) Ribbon

  I) Ribbon Tabs

  J) Quick Access Toolbar

  K) Column Letters in Column Header

  L) Cells

  M) Status Bar

  N) Zoom Slider

  
• FORMULA

  • AN EXPRESSION THAT OPERATES ON VALUES IN A RANGE OF CELLS
  • THESE FORMULAS RETURN A RESULT, EVEN WHEN IT IS AN ERROR
  • EXCEL FORMULAS ENABLE YOU TO PERFORM CALCULATIONS SUCH AS ADDITION, SUBTRACTION, MULTIPLICATION, AND DIVISION.
• EXCEL FORMULAS

  • SUM
  • AVERAGE
  • COUNT
  • SUBTOTAL
  • MODULUS
  • POWER
  • CEILING
  • LEN
  • REPLACE
• SUM


  THE SUM() FUNCTION, AS THE NAME SUGGESTS, GIVES THE TOTAL OF THE SELECTED RANGE OF CELL VALUES. IT PERFORMS THE MATHEMATICAL OPERATION WHICH IS ADDITION.
• AVERAGE


  THE AVERAGE() FUNCTION FOCUSES ON CALCULATING THE AVERAGE OF THE SELECTED RANGE OF CELL VALUES
• COUNT


  THE FUNCTION COUNT() COUNTS THE TOTAL NUMBER OF CELLS IN A RANGE THAT CONTAINS A NUMBER. IT DOES NOT INCLUDE THE CELL, WHICH IS BLANK, AND THE ONES THAT HOLD DATA IN ANY OTHER FORMAT APART FROM NUMERIC.
• SUBTOTAL 


  THE SUBTOTAL() FUNCTION RETURNS THE SUBTOTAL IN A DATABASE
• MODULUS 


  THE MOD() FUNCTION WORKS ON RETURNING THE REMAINDER WHEN A PARTICULAR NUMBER IS DIVIDED BY A DIVISOR.
• POWER 


  THE FUNCTION “POWER()” RETURNS THE RESULT OF A NUMBER RAISED TO A CERTAIN POWER.
• CEILING 


  THE CEILING() FUNCTION ROUNDS A NUMBER UP TO ITS NEAREST MULTIPLE OF SIGNIFICANCE.
• LEN 


  THE FUNCTION LEN() RETURNS THE TOTAL NUMBER OF CHARACTERS IN A STRING.
• REPLACE 


  AS THE NAME SUGGESTS, THE REPLACE() FUNCTION WORKS ON REPLACING THE PART OF A TEXT STRING WITH A DIFFERENT TEXT STRING