ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Spreadsheet Packages

Updated on April 7, 2012

Spreadsheet is a name for all programs designed to handle all accounting and statistical problems. A spreadsheet is an electronic version of the manual worksheet used to organized and manipulate numbers and displays options for what-if analysis. it is based on the traditional accounting worksheet that have long been used by accountants and managers to work balance sheets, sales projections and expense budgets. spreadsheets are also used by financial analysts, contractors and other businessmen concerned with manipulating numeric data. Before the introduction of electronic spreadsheet, the ledger was the accountant's primary tool for recording financial transactions. Any application that has to do with rows and columns is an application for spreadsheet. some of these application includes income statements, demographic data, budget summaries e.t.c. spreadsheets are important because they handle spreadsheet problems exceptionally well. At the heart of any spreadsheet is a column of information, such as set of prices for set items that need to be worked on such as addition. with manual spreadsheet, someone would have to look up the prices, perform the calculation, and then write down the result.

Apart from all the time this takes there is the possibility of errors. The electronic spreadsheet on the other hand, will do all the calculations in a matter of split second, prints out the result the way you want with virtually no chance of errors. You can manipulate numbers by using stored formulas and calculate different outcomes. For example, a retail store manager can estimate quarterly profits by projecting sales over a three-month period. The manager can subtract expenses resulting from advertisement, cost of goods and salaries. if he sees that expenses are too high to produce a profit, he can experiment on the screen by reducing some expenses and see the result immediately.

Structure of Spreadsheet


A spreadsheet is organized in a tabular structure with rows and columns. it has several parts- the worksheet area of the spreadsheet, which displays the row and column table. The rows are usually numbered down the left side while the columns are lettered across the top. The columns run from A,B,C,..AZ and so on up to 256 columns. most spreadsheet packages permit up to 8196 rows or more depending on the size of the RAM. The intersection of a row and column designates a cell. Data is entered and held in a cell. The position of a cell is celled cell address. In the worksheet area of rows and columns movable highlight is used to point to the cells. This highlight is known as the cell pointer and can be moved around with the cursor-movement(arrow keys to any cell address in much the same way that you move the insertion point in a word processor.

Entering Data


All that is required to enter data in the spreadsheet is simply moving the pointer to the appropriate cell using the cursor-control keys, and then keying in the data. You also move the pointer to the appropriate cell in order to edit an already keyed data. The address and content of the current cell are usually displayed in the user-interface portion of the spreadsheet-top corner of the spreadsheet work area. Whatever you are keying into a cell is displayed as you typed the characters. When you finish typing, the ENTER key or the cursor-control key is pressed to insert the data into the cell where you have the pointer. if it is the arrow key that was pressed, the data is inserted and the pointer moves to the next cell.

Types Of Data Entries


There are three classifications for the information (data) that we can put in a cell. if the data is a text such as a person's name, title or heading, it is classified as label entry. A label (text) entry is a word, phrase, or any string of alphanumeric text (space included) that occupies a cell. A numeric entry is classified as value. The third classification is formulas, which are instructions for calculations. They calculate results using numbers in referenced cells. for example, to calculate the total for a set of cells, first you need to position the pointer in the cell where you want to have the total usually at the end of a row or column for the set of cells. You should tell the spreadsheet that what you want to enter is a formula, not a label or value. in some spreadsheets, you do this by typing the @ sign. In Excel you use the = sign. A typical example is =D2+A5. This means add the value in D2 to the value in A5. The result of this calculation will be displayed wherever the pointer is positioned. Spreadsheet formulas use standard notation for arithmetic operations: +,-,*,/,^. Unless otherwise specified, numeric entries are right justified. you can however, specify otherwise. you can also center your entry in the cell.

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      Osei samuel 

      7 weeks ago

      Meaning of spreadsheet package

    • profile image

      sajjad06 

      11 months ago

      how advance excel can be apply in business management for quick effeciency.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)