Charts (Bar, Column, Pie, Line)

  • A spreadsheet, also known as a worksheet, is a row and column arrangement of data and the formulas to manipulate the data.
  • A spreadsheet can be used for a variety of applications like business forecasts, inventory control and accounting.
  • Every Excel file is a workbook that can contain more than one worksheet.
  • Cell is defined as the space where a specified row and a column intersect.
  • Worksheets can contain labels, numbers or formulas.
  • Worksheet allows selecting both contiguous and non-contiguous cells.
  • A range is a group of cells referenced with a name. The range reference consists of the first and last cell addresses separated by a colon.
  • The AutoSum button on the Standard toolbar adds numbers automatically and also suggests the range of numbers to be added.
  • Formulas and functions are automatically updated with a change in the source cell or position of the formula.
  • In Relative referencing, the reference is adjusted relative to the new location of the formula.
  • In Absolute referencing, the cell reference does not change but remains fixed while pasting formulas.
  • Functions are pre-written formulas which must begin with an “=” sign.
  • Cell ranges can be named and used in place of cell references.
  • The AutoFill handle is a very useful tool to fill in logical series.
  • Cell comments are additional explanatory notes which can be attached to a cell in a spreadsheet.
  • Charts are an excellent tool to present data graphically and also help in analysing and comparing data.
  • The most powerful feature of a spreadsheet package is the “What-if analysis”. Using this feature, we can change values and immediately see the effect as the entire worksheet is automatically updated, based on the change in the values.