Preview

Project Ms Excel

Good Essays
Open Document
Open Document
4275 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Project Ms Excel
INTRODUCTION TO MS-EXCEL -

Ms-Excel is a full-featured window based spread sheet program developed by Microsoft Corporation is used by millions of people around the world. Excel includes all standard features of a spread sheet package like automatic recalculation, graphs and functions. It includes several advanced utilities like facility to include other objects within a spreadsheet, table and form designing.
Ms-Excel is developed on the GUI concept. A spreadsheet is a highly interactive computer program that consists of a collection of rows and columns that are displayed on the screen in a scrollable window. The intersection of each row and column is called a cell. A cell can hold a number of text string or a formula that performs a calculation using one or other cells.
Excel is used for a variety of applications. It is commonly used to automatic financial statements, business forecasts, transition registers inventory control, accounts receivable and accounts payable. The package provides statistical, analytical and scientific functions. Therefore, Excel is used in many scientific and engineering environments to analyze numerical data and present findings. Excel comes across as a powerful and flexible graphical presentation tool. Excel is also able to access data stored in Database formats. Excel may also used as a powerful application development tool.

FEATURES OF MS-EXCEL -

Ms-Excel is application software based on electronic spreadsheet made by Microsoft. This software allows us to retrieve data from external data sources and use it in worksheet.
Ms-Excel has a number of features. Some of the features of Ms-Excel are as follows-
1. Excel has 65536 rows and 256 columns in it.
2. It supports what if analysis to help predict the future values if there is a change in the cell content which is referred to in the formula.
3. Based on the data, graphs or charts can be created for quick assessment of a situation.
4. Excel provides facility of

You May Also Find These Documents Helpful

  • Good Essays

    U42 P1

    • 574 Words
    • 3 Pages

    A spread sheet is a grid that sorts data into columns and rows, spread sheets make entering and illustrating data, spread sheets also allow you to input formulas which can be used to work with the data. Microsoft Excel provides you with a variety of different ways of graphically showing this data after it has been sorted with graphs or coloured tables or even just plain. Entering formulae into the database allow you to program the desired spread sheet to add subtract and a many more. Spread sheets are also very compatible with the various other programmes such as Access, because of the compatibility you are enabled to import information from one programme to another. Using spread sheets would considerably lower the risk of mistakes made by the managers and accounting team especially when dealing with the income, outgoings and profitable money.…

    • 574 Words
    • 3 Pages
    Good Essays
  • Good Essays

    It206 Wk4 Scenarios

    • 918 Words
    • 4 Pages

    The challenge in this situation is that the user wants to use a program that is new to him. I will have to explain to the user the basic functions of Excel to see if those functions match what the user wants to do.…

    • 918 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Tips for Pam and Sue

    • 1337 Words
    • 6 Pages

    Basic Excel skills you need are the ability to construct histograms and scatterplots, to create dummy variables, copying or moving columns of data in a spreadsheet, and the ability to use the Correlation and Regression facilities under Data Analysis (available when Analysis ToolPak has been added in). Remember that Analysis ToolPak requires contiguous ranges of data for correlation or regression.…

    • 1337 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Unit 42 M3

    • 430 Words
    • 2 Pages

    The following states some of the automated features available within Excel spreadsheets. By implementing these within the spreadsheets can really benefit the end users.…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    There is one upside to dealing with spreadsheet applications rather than a database. I had just touched on the subject of crunching numbers earlier but let’s revisit that now. When dealing with possible such as future profits, target zones, or estimating net gains for a company it is much easier to do the work within a spreadsheet application and then use that information and upload it to a database system( ). The complexity of…

    • 817 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    TASK 3

    • 329 Words
    • 1 Page

    In my opinion, one of the many benefits of using spreadsheet to Fireball Technology company is it allows the company to carry out simple or complicated calculations using numerical data and formulae. The many functions Microsoft Excel provides such as tools to analyze and visualize data sets in accessible ways. If you have a set of data statistical, numerical or financial information, you can use a spreadsheet not only to store this data but also to manage it, perform analytical processing on it and present it. Spreadsheets provide complex processing in ways that even people with little technical experience can access.…

    • 329 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Many organizations use spreadsheets to keep record of financial, employee, customer, and vendor information. Spreadsheets make it easier to create budgets, calendars, invoices, and contact lists. With Microsoft Excel, it can be linked to other programs such as Microsoft Word and Access. Spreadsheets help to compile a company’s data into user friendly data.…

    • 513 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    • Spreadsheet - A spreadsheet is usually a numerical document created on a computer used for calculating, sales, accounts creating graphs etc.…

    • 1763 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Excel Chapter 1

    • 4708 Words
    • 19 Pages

    B) the current cell location of the insertion point as indicated by a dark border.…

    • 4708 Words
    • 19 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A spreadsheet is an electronic worksheet made up of columns and rows of data. Spreadsheet software allows the user to “create, calculate, edit retrieve, modify, and print graphs, charts, reports, and spreadsheets” necessary for current business operations and in planning for the…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Microsoft Excel is an electronic spreadsheet. It can be used in several ways for several tasks. Excel is used to manage, store and calculate different types of information. One of the uses for Excel would be keeping track of a company’s warehouse inventory.…

    • 816 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Ss2 Assesment

    • 1737 Words
    • 7 Pages

    In order to achieve your Level 2 ITQ Certificate in IT User Skills qualification, you will need to demonstrate to your tutor that you can meet all of the learning outcomes for this Unit.…

    • 1737 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    SS2 Assessment

    • 2272 Words
    • 11 Pages

    1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

    • 2272 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Speed – A computer can search through files and records quickly to find the information you require. It can also make it quicker and easier to change a mistake.…

    • 1465 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    We will use Spread sheet for storing, calculating, filtering, verifying, sorting, displaying, creating graphic charts etc. . . . Its use is much extended now days to show large amount of data. We can use spread sheet electronically or be printed for show.…

    • 3504 Words
    • 15 Pages
    Powerful Essays