Wednesday, December 2, 2015

Introduction to MS Excel

In this tutorial you will learn about introduction to MS excel.

MS Excel is application software. It is used for calculation and data analysis such as pivot table, analysis, goal seek & scenarios, that all made excel a powerful & useful tool. You can also insert graphs or charts and perform complex calculations. Data is stored in rows and columns format. By default excel workbook contain 3 sheets.

Various components of excel spreadsheet are illustrated below.

Title Bar :-  Its display the name of the excel spreadsheet. By default spreadsheet name is Document1 or Book1.

Menu Bar :- It is a primary function of any application. Menu Bar is a thin rectangle, which is typically located at the top of the screen and below the title bar, containing drop down menu.

Button Bar :- It is a set of multiple buttons joined into a separate control. In Button Bar every Button has a text label or icon or both.

Formula Bar :- When we use any formula in an excel spreadsheet then it is displayed in the formula bar. 

Sheet tab :-  When we open excel, we always see that excel automatically selects sheet 1 for us. If we want, we can rename, delete, move and change colour of the sheet by right clicking on it. We can also hide and protect the sheet.

Use shortcut key Alt+Shift+F1 to create a new sheet.

Name box :- It display the name of the currently selected cell. For example H6, A5, B3, etc. In H6, H is the column name an 6 is the row number.

Other Important MS Excel Information

1 Excel file = 1 Workbook = 255 sheets

Total Number of rows = 65536

Total Number of columns = 256

Total Number of cells = Rows * Columns 
65536 * 256 = 16777216 Total Cells.

Rows are numeric and columns are alphabetical.


Above image shows that we are working in excel using cell address. They are made up of the combination of rows and columns. For creating cell address, first column name and then row name is written. 

A2, H5, B2, C4, D5, these are cell addresses. A is Column and 2 is Row. All type of calculations are performed using cell address. Cell address can be viewed in Name box.

If you have found any mistake or have any doubt related to above introduction to MS excel tutorial then comment below.

4 comments:

  1. i think you create a new website and this is your startup in this topic
    hey i want home tab in ms excel

    ReplyDelete
  2. UFC puts out TUF 26 throwing call for three weight classes. The UFC issued a throwing call Wednesday for contenders in three weight classes for the most recent period of the FS1-communicated arrangement: ladies. 'TUF 26' tryouts slated for May 23; male and female UFC hopefuls. UFC on FOX 24's "Jacare" Souza won't down from unsafe battles. RIO DE JANEIRO, Brazil – Ronaldo Souza wasn't shocked when the UFC reacted to his demand for a battle with the name of rising.
    UFC 210
    UFC 210 Live , UFC 210 Fight Card , UFC 210 Fight , UFC 210 Card , UFC 210 Live Stream , UFC 210 PPV



    Two years into UFC title rule, Daniel Cormier as yet battling for regard Meanwhile, after a long keep running as the prevalent belt in the UFC, light ... Daniel Cormier, the current UFC light heavyweight champion, is set to. UFC 210 early say something comes about and live video stream (9 am ET Predictions for each battle on the UFC 210: Cormier versus Johnson 2. UFC 210 Odds And Best Bets For The Biggest Fights And Bonuses.
    UFC 210
    UFC 210 Live , UFC 210 Fight Card , UFC 210 Fight , UFC 210 Card , UFC 210 Live Stream , UFC 210 PPV

    ReplyDelete

  3. For complete protection of UFC Fight Night 136, take a look at the UFC Events section of the site.

    The Blue Corner is MMAjunkie's website area. We do not take it too seriously, and neither should you. Should you come whining to us that something which you just read isn't hard-hitting news, expect to have the previous sentence replicated in ALL CAPS.
    UFC 229 Live Stream

    ReplyDelete

  4. Fast forward to the conclusion of Jedrzejczyk's scrum alongside a reporter circled back into asking her for a prediction. When Jedrzejczyk revealed she was 50/50, the reporter subsequently altered to asking her about McGregor's behavior.
    UFC 229 Live Stream Online

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.