ms excel

Study Notes




Microsoft Excel is a software program
produced by Microsoft that allows users to
organize, format and calculate data with
formulas using a spreadsheet system. This
software is part of the Microsoft Office
suite and is compatible with other
applications in the Office suite


What is MS Excel and its advantages?
MS Excel is a simple software and learning
the basics can make students and
professionals job ready. Beginners will
always be concerned about the basic
features like rows, columns, tables etc.
Easy data entry and operations: One of the
main advantages of MS excel is that it
facilitates smooth and easy data entry.


What is an Excel Function?
A function in Excel is a preset formula,
that helps perform mathematical,
statistical and logical operations. Once
you are familiar with the function you want

, to use, all you have to do is enter an
equal sign (=) in the cell, followed by the
name of the function and the cell range it
applies to.
The most frequently used functions in Excel
are:
 AutoSum;
 IF function;
 LOOKUP function;
 VLOOKUP function;
 HLOOKUP function;
 MATCH function;
 CHOOSE function;
 DATE function;
 DAYS function;
 FIND & FINDB functions;
 INDEX function


How to open MS Excel?
To open MS Excel on your computer, follow
the steps given below:
 Click on Start
 Then All Programs