Quantcast What is Microsoft Excel and how use it? | Source and Code System

What is Microsoft Excel and how use it?

Oct 12, 2010  ¦¦  by isr.coder  ¦¦  Microsoft Office  ¦¦  32 Comments

Excel is an Electronic Spreadsheet Program

Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.

When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

The intersection point between a column and a row is a small rectangular box known as acell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell reference or address to identify it.

The cell reference is a combination of the column letter and the row number such as A3, B6, AA345.

Data Types, Formulas, and Functions

The types of data that a cell can hold include numbers, text or formulas. Just as in math class, formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions.

Excel and Financial Data

Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of 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 mortgages.
  • Finding the average, maximum, or minimum values in a specified range of data.

Excel’s Other Uses

Other common operations that Excel can be used for include:

  • graphing or charting data to assist users in identifying data trends.
  • sorting and filtering data to find specific information.

The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.

The Original “Killer App”

Spreadsheets were the original killer apps for personal computers. Early spreadsheet programs such as VisiCalc and Lotus 1-2-3 were largely responsible for the growth in popularity of computers like the Apple II and the IBM PC as a business tool.

32 Comments

  • What is Microsoft Excel and how use it? | Source and Code System…

    Thank you a lot for providing people who have a very breathtaking chance to read critical reviews from this site. It is actually very brilliant and as well , filled with fun for me personally personally and my office co-workers to find your internet si…

  • What is Microsoft Excel and how use it? | Source and Code System…

    My brother suggested I might like this website. He was totally right. This post actually made my day. You can not imagine just how much time I had spent for this info! Thanks!…

  • social marketing…

    [...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]…

  • TV Lamps…

    The Truth behind Television Replacement Lamps….

  • adult social network…

    [...]below you’ll find the link to some sites that we think you should visit[...]…

  • Found=> Mentions You…

    [...]we found a vеry good site which yоu mаy enjoy. Have а lоok if yоu want[...]…

  • Great Clips Coupons…

    [...]in the following are a couple of web page links to sites I always connect to for the fact we believe they are well worth browsing[...]…

  • Coolest news on the planet, you have to see this !…

    [...]the time to read or visit the content or sites we have linked to below the[...]…

  • Gaming Blog Link To Your Post…

    [...]please go tо the sites we follow, including this blog, simply because іt represents our picks from the web[...]…

  • Recent Blogroll Additions……

    [...]usually posts some very interesting stuff like this. If you’re new to this site[...]……

  • buy damansara house…

    [...]you will find information that’s relevant to you if you want to buy damansara house[...]…

  • Garmin1490t.com…

    [...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]…

  • Read was interesting, stay in touch……

    [...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……

  • Sources…

    [...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……

  • Sites we Like……

    [...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……

  • Angry Birds Online…

    [...]following are a few links to web-sites we connect to for the fact we feel there’re really worth browsing[...]…

  • A Star wars Fan Site Mentions You…

    [...]What blogs for political commentary do yоu recommend mе you juѕt read?[...]…

  • Visitor recommendations…

    [...]one of our visitors recently recommended the following website[...]……

  • basketball drills…

    [...]here are some links to sites that we link to because we think they are worth visiting[...]…

  • affordable webhosting…

    [...]Sharing this information with our webhosting shoppers[...]…

  • Digg…

    While checking out DIGG yesterday I noticed this…

  • I’ve been brain vampired…

    I just lost 74 IQ points, gone by reading this blog topic….

  • Must Read Contribution…

    The article is surely recommended by us….

  • Sources……

    [...]take time to read or check out the content of these sites we have linked to below[...]……

  • Ipad Stylus…

    [...]pursuing are some links to internet sites which we connect to seeing as we think they will be really worth checking out[...]…

  • travel…

    [...]the time to read or visit the content or sites we have linked to below the[...]…

  • Tips on how to improve your Wedding !…

    [...]here are some links to sites that we link to because we think they are worth visiting[...]…

  • Wikia…

    Wika linked to this site…

  • News info…

    I was reading the news and I saw this really cool information…

  • 10 great ways to improve your website ranking…

    [...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…

  • Splendid…

    I really great this story!…

  • Check this out…

    [...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……

Leave a comment

*