SPREADSHEET

SPREAD SHEET

A Spread sheet application is productivity software in which a computer user can manage personal and business finance with the help of a spread sheet program.

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheet users may adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for “what-if” analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.

Productivity software is a software that assists people to gain more efficiency and effectiveness while performing daily activities. You can use a spread sheet program to perform calculations, analyze data and present information.

EXAMPLE OF SPREAD SHEET

1.                   LOTUS 1-2-3: This is a spread sheet program from lotus software (now part of IBM) which has added integrated charting, plotting and database capabilities

2.                   STATVIEWS: This is a spread sheet program than can perform many analyses by template. It creates presentation quality graph and table with a singles of the mouse.

3.                   MICROSOFT EXCEL: This is powerful spread sheet that allows you to organize data complete calculate take decision, graph data and develop reports. It is also has basic features to help you create, edit and format worksheet.

GRAPH IN EXCEL

A graph is a great way of representing your data. With graph, data are easily understood and also they are easily edited for better data presentation. You can create dozens of different charts, from pie chart to bar chart and more.

DATA SENSE: This is the foundation of any chart in the worksheet that you use to create. Chart data is the content of a group of related cells, such as one row or column of data in your worksheet.

CUSTOMIZED CHARTS: Any chart created can be customized and can also change to the formatting of the chart, text, change the chart type and much more.

CHART TYPES

1.                   COLUMN

2.                   BAR

3.                   LINE GRAPH

4.                   PIE

5.                   SCATTER

6.                   AREA

7.                   DOUGHNUT E.T.C

 

WORK SHEET

Worksheet commonly refers to a sheet of paper with questions for students and places to record answers. The term may also refer to a single array of data in spreadsheet software or an informal piece of paper that an accountant uses to record information.

A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Excel or Google Spreadsheets. A worksheet is used to store, manipulate, and display data. A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.

Each worksheet is composed of a very large number cells – which are the basic storage unit for data in a file or workbook.

The cells are arranged in a grid pattern using rows and columns.

While a Workbook is the collection of several worksheets, so therefore it can be said that a Workbook comprises of multiple worksheets.

In Excel 2013:

• There are 1,048,576 rows per worksheet;
• There are 16,384 columns per worksheet;
• By default, each new file contains only one worksheet;
• The number of sheets per file is limited only by the amount of memory available on the computer.

* In earlier versions of Excel, the default number of worksheets per file was three.

For Google Spreadsheets:

·         There is a maximum of 256 columns per sheet;

·         The maximum number of cells for all worksheets in a file is 400,000;

·         The current default number of worksheets for new files is one;

·         There is a maximum of 200 worksheets per spreadsheet file.

Each worksheet also has a name. By default, the worksheets are named Sheet1, Sheet2, Sheet3 and so on.

Copy and use the Class code: 02276781

Take Test