MS Excel Tutorials

MS EXCEL

MS Excel कंप्यूटर का एक ऐसा Software है, जिसे एक छोटे से लेकर बड़े बिजनेस में use किया जाता है। आमतौर पर MS Excel का उपयोग Data को अपने तरीके से Organize करने और data Analysis करने के लिये किया जाता है| 

MS Excel एक spreadsheet software है जो की  Rows & Columns  का combination से  मिल कर बना होता है 

HOW TO OPEN MS EXCEL

Step1- Left click on Windows Button 
Step2 - Left click on All Programs 
Step3 - Left click on Microsoft Office
Step4 - Left click on Microsoft Excel 2016



What is a spreadsheet?

A spreadsheet is the computerized equivalent of a general ledger. It has taken the place of the pencil, paper, and calculator. The electronic spreadsheet is laid out similar to the paper ledger sheet in that it is divided into columns and rows. Any task that can be done on paper can be performed on an electronic spreadsheet faster and
more accurately.

The Ribbon

The Ribbon is designed to help you quickly find the commands that you need to complete a task. The  Commands are organized in logical groups, which are collected together under Tabs. Each Tab relates to a type of activity, such as formatting or laying out a page. To reduce clutter, some Tabs are shown only when needed. For example, the Picture Tools tab is shown only when a picture is selected.

Formula Bar 

A place where you can enter or view formulas or text.

Columns and Cells and Row

The horizontal bar across the top of the worksheet area is filled with letters, beginning with A. Each letter represents a column while the vertical bar on the left side of the worksheet filled with numbers refers to rows Each number represents a row .

Cell 

Cell make with the column and row , Each cell has its own address. This address is used in formulas for referencing different parts of the worksheet. The address of a cell is defined by the letter of the column in which it is located and the number of the row.  For example, the address of a cell in column B, row 5 would be referred to as B5.


How to save workbook in excel 

When you create a workbook it is important to save the workbook so that it can be viewed or reused later. The basic steps to save a workbook are listed below;
1. Click on the File Tab
2. Click on the  Save As or Save (Ctrl + S , F12) xlsx, pdf file
3. it displays 'Save As' Dialogue Box
4. Save the workbook to desired location with a desired name


Post a Comment

0 Comments