What is spreadsheet? Write its application, advantages & disadvantages.

Spreadsheet Software: Spreadsheet program is used is used for calculations. It provides worksheets to enter data. A worksheet is a collection of rows columns. It allows you to make different calculations using formulas and built-in functions. We can also display our data using charts and figures.

Spreadsheet_Software

Application of Spreadsheet

Some important applications of spreadsheet program are as follows:

  • It can be used by corporations to track profit and losses
  • Economists can generate growth graphs of country’s economy
  • Statisticians can calculate probability of crashing the market
  • Women can manage their household budgets

Advantages

Computerized spreadsheets can calculate data easily, accurately and efficiently. Large quantities of numbers can be added, subtracted, multiplied and divided. Revised calculations are performed automatically when new information is inserted in existing spreadsheet.

  • It increases the ease and speed of calculating.
  • It makes it easy to modify information and recalculate automatically.
  • It displays numeric data as a chart or graphs.
  • It incorporates numeric data into another software application.

Disadvantages

  • Spreadsheet program cannot process a large volume of data quickly.
  • It does not provide much programming facilities.

Discuss the basic feature of spreadsheet software

basic-feature-of-spreadsheet-software

 

Spreadsheet software provides many features. Some are as follows:

  1. Grid of Row and Columns

The spreadsheet is a grid of rows and columns. Each row is assigned a number and each column is assigned a latter. The intersecting of row and column is called cell. Cells are identified by the combination of their column letter and row number.

For example, fifth cell in the second column is known as cell B5. This is known as the cell address or cell coordinates. A cell contains labels or values. A label is text entry such as “Gross salary”. Values can be number, date, formula or formula result.

  1. Formulas

The formula performs calculations on the data in spreadsheet. It displays the resulting value in the cell containing the formula.

  1. Built-in Functions

Spreadsheet has many built-in function s. functions can perform different types of calculations. Lengthy calculations can be applied on worksheet easily by using functions.

  1. Commands

Commands are used to manipulate the worksheet or its contents

  1. Text Manipulation

Some simple text manipulation can also be performed.

  1. Printing

Spreadsheet provides printing facility. You can print your documents to get a hard copy. Printing can be of whole document or of any required range.

Explain the general interface of spreadsheet software. Also explain 3-D sheet.

Following is brief description of different elements of a spreadsheet interface:

  1. Worksheet

The worksheet is where data is entered. Spreadsheet consists of columns and rows to enter data.

  1. Workbook

Workbook is a group of worksheets saved together as one file. By default a workbook contains 3 worksheets.

  1. Cell

The intersection of row and column is called cell. A cell holds data. Cells may contain text, numbers graphical patterns or formulas.

  1. Cell Address

Cells are identified by the combination of column letter and row number. The fifth cell in second column is known as cell B5. This is known as the cell’s address or cell coordinates.

  1. Column and Row Headings

The text that appears at the top of column is called column headings. Column headings represent the names of the columns. The text the appears on the left of row is called row headings. Row headings represent the names of the rows.

  1. Active Cell

Active cell is the in which data is entered or edited at a given time.

  1. Title Bar

Title bar is located at the very top of the screen. Spreadsheet displays the name of the current workbook on it.

spreadsheet_Title_Bar

  1.   Menu

Menu is a collection of useful commands displayed on the top of screen.

  1.   Toolbars

Toolbars are shortcuts to menu commands. Toolbars are generally located just below the menu bar. Toolbars consist of icons that act as shortcuts to the commands.

  1.   Formula Bar

The formula bar displays the location of the active cell and the value or formula used in the active cell.

  1.   Sheet Tabs

Sheet tabs at the bottom of the workbook are used to move from one sheet to another in a workbook.

  1.   The Status Bar

At the bottom of the spreadsheet interface is the status bar. This bar displays information about a command, a toolbar icon or an operation in progress.

  1.   3D Sheet

Early spreadsheet programs provided only one worksheet at a time. The workbook could contain just one worksheet. The new spreadsheets are called 3D worksheet. A 3D worksheet is like a pad of worksheets. It is due to this feature that data in one worksheet can be used in the calculations of another worksheet of same or different workbook.