Microsoft Excel (Excel-01)- Introduction

Microsoft Excel is known as spreadsheet. Spreadsheet consist of Rows and columns. Excel is mainly used for calculation purposes, working with numbers and formulae like making salary sheets, student DMC and other financial tasks.

As discussed Excel consist of Rows and Columns. in Excel 2013 and above version there are 1048576 Rows and 16384 Columns.

when a row and column intersect each other then it form a cell. there 17,179,869,184 cell in excel 2013 and onward version.

each cell has its own address. for example if column A intersect Rows 1 then this cell address is A1. This address is very useful and most important in entering formulae in excel. So now lets see how excel starts and how its interface look like.

in search write Excel and click Excel or click on short cut on desktop

The vertical line are columns and horizontal line are columns and collectively they form gridlines.

Ribbon in Excel

We will mostly discuss the formulae and calculation related task as other commands are mostly same to Ms Word.
So lets start learning by some basic commands in Excel

• What is Sheet

A sheet is a collection of columns and Rows. A file in in Excel consist of one or more sheets.

• What is workbook

A File in Excel is called Workbook. Workbook may have one or more sheets. You can insert more sheets in a workbook by clicking the + sign next to existing sheet.

similarly you can rename a sheet and change color of that sheet name. You can type Data in cell by clicking in that cell and can edit data by pressing F2 button.

To Enter formulae in Excel you must use = sign before every formula starting. This thing must be kept in mind.

for example to add two or more numbers we use the formula:=sum(a1:a5)

This mean to sum numbers from Cell A1 to Cell A5

=A1-A2

This mean to subtract number in A2 Cell from A1 cell data

= A1*A2
This mean to multiply number in A1 cell with A2 Cell
=A1/A2
This mean to divide Number in A1 cell by number in A2 cell
There are hundred of formulae and functions in Excel which we will discussed and learn. So keep follow my blog site

Much of the commands of Excel are same to Word like save, save as , open , cut , copy , paste, page size, page layout etc. etc.

The upper command bar is called Ribbon. There are File Home, Insert and Page layout menu like Ms Word but the menu of Formula, Data menus are special in MS Excel.