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.
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
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.
- Spreadsheet program cannot process a large volume of data quickly.
- It does not provide much programming facilities.
Discuss the basic feature of spreadsheet software
Spreadsheet software provides many features. Some are as follows:
- 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.
The formula performs calculations on the data in spreadsheet. It displays the resulting value in the cell containing the formula.
- 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.
Commands are used to manipulate the worksheet or its contents
- Text Manipulation
Some simple text manipulation can also be performed.
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:
The worksheet is where data is entered. Spreadsheet consists of columns and rows to enter data.
Workbook is a group of worksheets saved together as one file. By default a workbook contains 3 worksheets.
The intersection of row and column is called cell. A cell holds data. Cells may contain text, numbers graphical patterns or formulas.
- 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.
- 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.
- Active Cell
Active cell is the in which data is entered or edited at a given time.
- Title Bar
Title bar is located at the very top of the screen. Spreadsheet displays the name of the current workbook on it.
Menu is a collection of useful commands displayed on the top of screen.
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.
- Formula Bar
The formula bar displays the location of the active cell and the value or formula used in the active cell.
- Sheet Tabs
Sheet tabs at the bottom of the workbook are used to move from one sheet to another in a workbook.
- 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.
- 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.