Home Digital Technology Spreadsheet Visit W3Schools! About Us

    Spreadsheet

    Spreadsheet which is found in Microsoft excel is referred as worksheet or just call as spreadsheet,spreadsheet is a data file made up of rows and columns that are used to sort data and allow a user to manipulate and arrange data easily basickly numerical data. Spreadsheet software program is unique as its ability to calculate values using mathematical formulas and the data in the cells. Each value can have a predefined relationship to other values. The types of data that cell can hold include numbers, text or formulas, formulas are used for calculation usually involving data contained in other cells. A spreadsheet is often used to store a financial data. Formulas and functions data that can be used on financial data include:

  • Performing basic mathematical operations such as summing columns and rows of figures.
  • Finding values such as profit or loss.
  • Calculating repayment plans for loans or mortagages.
  • Finding the average,maximum,or minimum values in specified range of data.