LESSON 4

• Microsoft Excel


  Provides an automated way of displaying any statistical data. It can be used to automatically compute for several factors that are not easy to notice especially when faced by a large data. Microsoft Excel includes several arithmetic and basic functions that help you compute faster
• MS-EXCEL PARTS AND FUNCTIONS

  A) QUICK ACCESS TOOLBAR

  B) TITLE BAR

  C) FILE TAB

  D) NAME BOX

  E) SELECT ALL BUTTON

  F) ACTIVE CELL

  G) ROW HEADINGS

  H) SHEET TABS

  I) SHEET TAB SCROLLING BUTTON

  J) STATUS BAR

  K) FORMULA BAR

  L) COLUMN HEADINGS

  M) WORKSHEET WINDOWS

  N) RIBBON

  O) VERTICAL SCROLL BAR

  P) HORIZONTAL SCROLL BAR

  Q) ZOOM CONTROL

  R) VIEW SHORTCUTS
• •View Shortcuts 


   – Buttons used to change how the worksheet content is displayed. Normal, Page Layout or Page Break Preview.
• Sheet Tabs


  •Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc. You can rename this to any name the best represent to your sheet.
• Sheet Tab Scrolling Buttons


   Buttons to scroll the sheet tabs in the workbook
• Row Headings


  The number that appears on the left of the worksheet window to identify the different rows.
• Select All Button


  A button that selects all the cells in the active worksheet
• Active Cell


  •The cell selected in the active worksheet
• Name Box


  A box that displays the cell reference of the active cell
• Formula Bar 


  A bar that displays the value or formula entered in the active cell
• Office Button/File Tab


  It provides access to workbook level features and program settings. You will notice that in Excel 2007  there is a circle Office button while on the Excel 2010 it replace with File Tab. If you click the circle office button you will see this
• SUM


  Adds up all the numbers in a range of cells.
• AVERAGE


  Calculates the average of a range of cells.
• MAX


  Returns the largest number in a range of cells.
• MIN


  Returns the smallest number in a range of cells.
• IF


  Performs a logical test and returns one value if true and another if false.
• XLOOKUP


  Searches for a value in the first column of a table array and returns a value in the same row from another column
• CONCATENATE


  Joins together two or more text strings into one string.
• COUNT


  Counts the number of cells in a range that contain numbers.
• COUNTIF


  Counts the number of cells in a range that meet a given condition.
• SUMIF


  Adds up the numbers in a range that meet a given condition
• IFERROR


  Returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula
• ROUND


  Rounds a number to a specified number of digits.
• TRIM


  Removes extra spaces from text, leaving only single spaces between words
• LEN


  Returns the number of characters in a text string.
• LEFT


  Returns the leftmost characters from a text string.
• RIGHT


  Returns the rightmost characters from a text string.
• UPPER


  Converts text to uppercase.
• LOWER


  Converts text to lowercase.
• DATE


  Returns the serial number of a particular date
• TODAY


  Returns the current date.