what is ms-excel? Excel meaning

                                   MS - Excel 2010

Microsoft Excel This is an electronic spreadsheet, which is used to arrange and quickly calculate data in rows and columns. You can do things like salary sheet, mark sheet and quotation very easily in it.

Excel's file is called Workbook and a workbook has 3 sheets by default, which you can add or delete. A sheet of Excel 2010 consists of 10, 48, 576 rows and 16, 384 columns from the old Excel 2003. 1500% more rows and 6, 300% more columns. Extension Name of its file. xlsx occurs.

Getting Started MS Excel 2010: 

To start Excel 2010, click the Excel 2010 icon on the desktop: 


Go to Start → All Programs → Microsoft Office → Microsoft Excel 2010. 

The Excel 2010 window looks like this:


what is ms-excel Excel meaning


1) Name Box: - The cells in Excel are active, meaning the number of the cell in which we have clicked appears here. This box is in the left side of the formula bar.

2) Formula Bar: You can see the formula typed in Excel here, while its answer appears in the cell.

3) The Status Bar: The status bar is located at the bottom of the window and displays the current page number, Caps Lock, Num Lock etc. By right clicking on this bar, you can select another option.

4) Zoom Slider: This is the Zoom Slider on the status bar in the right corner of Vidi. Click on the plus or minus button to view the contents of the worksheet separately.

5) View Buttons: To change the layout of the workbook in the left side of the Zoom Slider, there are options of Print Layout, Full Screen, Webi Layout, Outline or Draft.

                  SOME IMPORTANT SHORTCUTS
Note: - In Excel, Row heading is represented by numbers (1, 2, 3....) And Column heading is represented by (A, B, C....).

Entering A series Using Auto Fill: - Assuming that the same type of data has to be written in a consecutive number or in a column, then in such a condition, we use Auto Fill.

To do this, do the following steps:


1. Click on the cell where you want to auto fill.

II. Now we will type a number in the first cell.

III. Then type the number in the second cell as much as it would type. .

IV. Now both will select the cell.

v. Now, by moving the cursor over the fill handle, we will drag in the direction to write.

Auto fills Example:


1
2
3
4
5
6
7
8
9
10


Sun
Mon
Tue
Wed
Thu
Fri
Sat



Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

                                   Mark sheet Data Entry

ROLL
ENG
MATH
HIN
SC
SSC
TOTAL
%
DIV
1001
65
68
53
39
50
275
55
2nd
1002
82
86
65
46
55
334
66.8
1st
1003
65
45
96
52
70
328
65.6
1st
1004
56
54
35
75
30
250
50
2nd

                               Billing Report Data Entry

CUSTOMER’S NAME
GOODS
UNIT
QUANTITY
RATE/UNIT
TOTAL
ROHAN
CPU
PCS
3
12000
36000
SOHAN
MOUSE
DOZEN
2
2550
5100
MOHAN
SMPS
PCS
5
330
1650
TINKU
MMC
DOZEN
8
1800
14400

Saving a workbook:

I. We will click on File Menu.

II. Now select the Save option. After doing this, the Dialogue box of Save As will open. .

III. Type your file name in it and click on the Save button.

Creating New Work Book:

I. We will click on File menu.

II. Now select the new option. After doing so, the Dialogue box of New Work Book will open. .

III. From that, select Blank Document Option and click on Create button

 Opening a Workbook:

I. Click on File Menu.


II. Now we will select the Open option. After doing this, the Dialogue box of Open Document will open.


III. Select your file name from it and click on Open button.

Post a Comment

0 Comments