CLASSINFOTECH

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).
MICROSOFT EXCEL

OVERVIEW OF MICROSOFT EXCEL

MICROSOFT EXCEL DESCRIPTION
  • 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.

VIEW OF MICROSOFT EXCEL SHEET

SOME EXAMPLES OF SIMPLE FORMULAS USED IN MICROSOFT EXCEL

SUM

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

AVERAGE

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

COUNT NUMBERS

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

MINIMUM

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

MAXIMUM

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

TO LEARN MICROSOFT WORD