Contents

What is Microsoft Excel- Learn Basic to Professional

Definition of Microsoft-Excel.

MS-Excel is also a content of MS-Office.
It is an application software which is required to be installed.
It is a formula based software, which perform all arithmetic and mathematical operations.
It is mainly used to maintain records of employees, students, expenses, incomes of any business or organization.
In MS- Excel, we work on sheets which we called “Electronic Spreadsheet”.
Extension name of Microsoft Excel is .xls (Excel Spreadsheet).

MS- Excel sheet looks like a big table which contains a number of rows and columns in it.
Rows and columns generate cells, the boxes shown on sheet are known as cells.
Number of rows in one sheet of Ms-excel is 10,48,576.
Ms-excel contain 16,384 number of columns in one sheet.
To find number of cells in one sheet of MS-Excel, we need to apply this formulas
- - - =number of rows * number of columns
    - =1048576 * 16384
    - answer is 17179869184.

so, there are 17179869184 number of cells available in a single sheet of Microsoft excel.

Every cell has a unique address or name.
While applying formula or function one should focus on values written in the cell nor on the address of cell.
Before applying any formula we must apply equals two mark, i.e, (=).
If A5 is written as address of cell, it indicates (A) as column heading and 5 as row number.

To get sum or add all values(numbers) of selected range.
- - Syntax:- =Sum(select range)

To find or get the average of all values(numbers) of selected range.
- - Syntax:- =Average(select range)

To count the cells having values(numbers) in selected range.
- - Syntax:- =Counta(select range)

To find the minimum value(number) among the selected range.
- - Syntax:- =Min(select range)

To find maximum value(number) among the selected range.
- - Syntax:- =Max(select range)

TO LEARN MICROSOFT WORD