Computer Q3

• Excel -

  • Is a spreadsheet application by microsoft
  • Allows users to organize and manipulate data that are arranged in columns and rows
  • It also lets us perform calculations, use graphing tool and create
  • Very usefool tool in data gathering
• Cell -

  • The intersection of a row and a column
• Cell address -

  • Is the combination of the column header and row number
• • To select the entire row, we click the row number
  • To select the entire column, we click the column header
• Data format-

  List:

  1. general
  2. Number
  3. Currency
• Worksheet -

  Collection of a cell in excel
• Workbook -

  Collection of a sheets
• Formula -

  • It is an expression that operates on value in a range of cells or cell
• Functions -

  • Are predefined formulas in excel
  • They eliminate laborious manual entry of formulas while giving them human friendly names
• Example of functions -

  SUM(A1: A3)
• Example of formulas -

  A1 + A2 + A3
• • In performing Excel calculations, cell address and cell range is important to get the data
• Cell range -

  • Is used to select multiple cells using a colon in between
• Example of cell address -

  A1
• Example of cell range -

  A1:A3
• • All functions and formulas in excel starts with an equal sign
• Sum -

  Is used to get the sum of the value in one or more cells
• Count -

  • Is used to count the numeric value in one or more cells or range
• Count A -

  • Is used to count the value in one or more cells
• Average -

  • Is used to get the value average in one or more cells or ranges
• Min -

  • Is used to get the minimum value on cell or ranges. Find the lowest
• Max -

  • Is used to get the maximum value on cells or ranges. Find the highest