Basics of Spreadsheet

Hi All,

Everyone should know what is spreadsheet and how to use it.

Here we will discuss the spreadsheet, where we store data in an organized manner.

In 1979, VisiCalc was introduced to the world as the first computer spreadsheet program.

Observation:- An observation includes all of the attributes for something contained in a row of a data table.

Formula:- A formula is a set of instructions that performs a specific calculation using the data in a spreadsheet.

In the spreadsheet, we are storing and managing the data by 3 simple features,

1. Cells:- Where we write our contents.

2. Rows:- Combination of cells in a horizontal manner. It describes each row's data in detail.

3. Columns:- Combination of cells in a vertical manner. It describes each column's data in detail.

To manage the data in a more organized manner, we use the sorting functionality (column-wise with respect to name/type/value, etc). The First row is basically column names by which we can do the sorting and managing the data.

Also, we can use formulas to find the Average, Sum, other mathematical calculations by inbuild functionality/features.

To use the Formula section, please type '=' in any cell which will automatically activate the selection of formulas. e.g:- Average of the Column, then the formula will be, =AVERAGE(C2:C6). So Syntax of the formula is =AVERAGE(<Starting_Cell>:<Ending_Cell>).

Keep Learning, Keep Improving.

Regards,

Nikhil