Another way to learn New Technology

What is spreadsheet and its features

0 6,278

What is spreadsheet and its features ?

Spreadsheet: It is a computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid containing alphanumeric text, numeric values or formulas. A spreadsheet also known as “Worksheet” contains rows and columns and is used to record and compare financial and numerical data.

It’s Features:

  1. A spreadsheet allows user to enter and calculate numerical data.
  2. Spreadsheet greatly increases productivity for anyone who needs to manage receipts, create ‘budgets’ generate financial reports.
  3. It combines the features of a general ledger with the flexibility of powerful data analysis and reporting function.

What do you mean by Spreadsheet Packages ?

Spreadsheet Packages: Business applications require a lot of calculation work. In manual system, it is done on a sheet of paper with rows and columns, which is called a “spreadsheet”. Spreadsheet packages use the concept of an electronic spreadsheet. An electronic spreadsheet (or worksheet) is a very big sheet consisting of thousands of rows and columns, which is used to store information in the memory of a computer. Like databases, electronic spreadsheets have now become an essential tool in developing a computerized management information system. Income statements, annual reports, balance sheet, cost analysis and budgets are some of the applications where worksheets are typically used.

Why is copy command used in a spreadsheet ?

Copy Command: The copy command can be used to copy the contents of one cell or group of cells into another cell or group of cells. This feature is particularly used when the same formula structure is to be used in several cells.

What is electronic spreadsheet and its advantages ?

Electronic Spreadsheet: It is used as a forecasting tool to project the impact of interest rate changes on a deposit or loan portfolio during future time periods and test various what-if hypotheses or interest rate scenario in each of those periods.

It’s advantages :

(i)     It is flexible.
(ii)    It is an important part of budgeting, financial planning.

What are the applications of spreadsheet ?

 Applications of Spreadsheet: There are currently many different high powered spreadsheets that have good graphical and presentation capabilities. They include programs such as LOTUS 1-2-3, Quattro Pro, Excel etc.

LOTUS 1-2-3: It is a spreadsheet program designed for IBM.

It’s features are:
1. It offers integral charting/graphic add database operation.
2. It had keyboard driven pop ups menus as well as key commands making it fast to operate.
3. It uses Macro to produce graphs and charts.

Microsoft Excel: It is a spreadsheet application that is used by millions of people around us.

Its features are:

1. It offers graphical tools, pivot tables and chart.
2. It helps to manage data in various formats, thus increasing productivity.

What is MS Excel ?

MS Excel: Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OSX.

Microsoft Excel is an electronic spreadsheet that runs on a personal computer. We can use it to organize our data into rows and columns. MS Excel gives us opportunity to learn and strengthen skills as we gather data, create worksheets, analyze and chart the results, and integrate our findings into reports and assignments.

For Example : Accountants use Excel to keep track of transactions for their company. Students might use Excel to help draw conclusions from the data, they gathered on a science project.