Spreadsheet definitions and uses

What is a spreadsheet?

A spreadsheet, also known as a worksheet, contains rows and columns and is used to record, compare, and process data. Originally, they only existed in paper format, but now they are most likely created and maintained through a software program that displays the numerical information in rows and columns. Figure 1 shows a basic example of what a spreadsheet - in Microsoft Excel - looks like as well as highlighting all the major components of a spreadsheet.

 

Computerized spreadsheets mimic their paper predecessors. In the software, the intersection of a row and a column is called a cell. Rows are generally identified by numbers — 1, 2, 3, etc. — and columns are identified by letters, such as A, B, C, and so on. The cell label or address is a combination of a letter and a number to identify a particular location within the sheet, such as A3. The advantage of using computer programs is their ability to update data and perform automatic calculations.

 

What are the uses of a spreadsheet? 

Spreadsheets can be used in any area or field that works with numbers and are commonly found in the accounting, budgeting, sales forecasting, financial analysis, and scientific fields. Teachers can use them to store and average grades, while other individuals can use them to track a personal budget or store sports team statistics. Scientists mostly use spreadsheets for math calculations and some basic database functions and for creating charts of - for example - time series data.

 

 

Figure 1 : An example of a spreadsheet (Microsoft Excel)

ACTIVITY FIVE

Comments

Post a Comment

Popular Posts

Suremoneyng Investment Review: Legit or Scam

What is Suremoneyng Investment? Suremoneyng Investment is a funding network, can also be called a Ponzi Scheme because of its operation, However Suremoneyng investment platform promises investors 100% profit on their investment. The first investment gets this 100% after 5 days. What’s more is that Suremoneyng investment allows users to withdraw only the profit amount and then capital when you cycle out. However, there is something I want you to know that majority of the people don’t realize. Suremoney says you get 100% profit on your first investment, but I say no. This is because the system does not allow you to withdraw both your capital and profit at once, when  due until you reinvest. Now, your investment can be anything from N5,000 to N50,000. You are also not allowed to make re-commitments lower than what you invested before. That is, if you invest 10,000 at start, the least amount of re-commitment is 10,000. But you are free to increase your investment. HOW DOES SUREMONEYNG ...
Read more

Dreams And Goals

A dream  or vision chart is a picture you can create using newspaper or magazine clippings that represent your dream, such as quotes or pictures and paste them onto a board. In this post I show you how to create your very own dream or vision chart.   Dreams V’s Goals   Dreams differ from goals in that your Dreams are your big goals. For example retire at 40, travel the world.  These are your dreams. How you get there are your smaller goals. Obviously only you can decide what you want your Dreams to be, but here we look at how you can make them real. How you can make them real is by using a technique called visualisation. This is where you ‘see’ your Dreams through pictures and words – it’s about making your dreams ‘real’ by grouping together pictures of the things that represent your dreams to you. Let me demonstrate this for you. Say you want to buy a new car. Let’s say it’s a BMW. Suddenly, every car you see on the road is a BMW.   Funny thing is, yo...
Read more