Microsoft Excel Tutorials

 

       What is Spreadsheet ? The terminologies  ,  Examples and features

A Spreadsheet made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. An example of how a spreadsheet may be utilized is creating an overview of your bank's balance.

Examples of a Spreadsheet Application are

Google Sheets , iWork Numbers , LibreOffice , Lotus 1-2-3 , Lotus Symphony , Microsoft Excel, OpenOffice etc.

 Below is an overview of the Microsoft Office excel, an example of a spreadsheet.

Some terminologiesin Spreadsheet

Workbook:

 The workbook refers to an Excel spreadsheet file. The workbook houses all of the data that you have entered and allows you to sort or calculate the results

Cell:

A cell is a rectangle or block housed in a worksheet. Any data that                         you want to enter into your worksheet must be placed in a cell.

Columns and Rows

Columns and Rows refer to how your cells are aligned. Columns are                      aligned vertically while rows are aligned horizontally.

Workspace

 Much like worksheets in a workbook, a workspace allows you to open numerous files simultaneously.

Formula Bar

 Nestled between the ribbon and workbook, the Formula Bar will display the contents of an active cell. In the case of formulas, the formula bar will display all components of the formula.

Features of a Spreadsheet application

Some common features of a Spreadsheet application are as follows

1.   Formatting toolbar

2.   Standard toolbar

3.   Formular bar

4.   Help facilites

For more information click on the phrase or text which is  in blue.