MS Excel Totorial

Posted on by Admin

What is MS Excel?

MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet.

How to open MS Excel?

To open MS Excel on your computer, follow the steps given below:

Click on Start
Then All Programs
Next step is to click on MS Office
Then finally, choose the MS-Excel option
Alternatively, you can also click on the Start button and type MS Excel in the search option available.

What is a cell?

A spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell. Given below is an image of a cell:

What is Cell Address?

The cell address is the name by which is cell can be addressed. For example, if row 7 is interested in column G, then the cell address is G7.

Features of MS Excel
Various editing and formatting can be done on an Excel spreadsheet. Discussed below are the various features of MS Excel.

Home
Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options
Insert
Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines, header and footer option, equation and symbols
Page Layout
Themes, orientation and page setup options are available under the page layout option
Formulas
Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions
Data
Adding external data (from the web), filtering options and data tools are available under this category
Review
Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part
View
Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category

Benefits of Using MS Excel
MS Excel is widely used for various purposes because the data is easy to save, and information can be added and removed without any discomfort and less hard work.

Given below are a few important benefits of using MS Excel:

Easy To Store Data: Since there is no limit to the amount of information that can be saved in a spreadsheet, MS Excel is widely used to save data or to analyse data. Filtering information in Excel is easy and convenient.
Easy To Recover Data: If the information is written on a piece of paper, finding it may take longer, however, this is not the case with excel spreadsheets. Finding and recovering data is easy.
Application of Mathematical Formulas: Doing calculations has become easier and less time-taking with the formulas option in MS excel
More Secure: These spreadsheets can be password secured in a laptop or personal computer and the probability of losing them is way lesser in comparison to data written in registers or piece of paper.
Data at One Place: Earlier, data was to be kept in different files and registers when the paperwork was done. Now, this has become convenient as more than one worksheet can be added in a single MS Excel file.
Neater and Clearer Visibility of Information: When the data is saved in the form of a table, analysing it becomes easier. Thus, information is a spreadsheet that is more readable and understandable.

MS Excel – Points To Remember

There are certain things which one must know with respect to MS Excel, its applications and usage:

  • An MS Excel file is saved with an extension of .xls
  • Companies with large staff and workers use MS Excel as saving employee information becomes easier
  • Excel spreadsheets are also used in hospitals where the information of patients can be saved more easily and can be removed conveniently once their medical history is cleared
  • The sheet on which you work is called a Worksheet
  • Multiple worksheets can be added in a single Excel file
  • This is a data processing application

MS Excel Questions and Answers

Given below are a few sample questions based on MS Excel which will help candidates preparing for competitive exams to score more in the Computer Awareness section.

Q 1. The address that is obtained by the combination of the Row number and the Column alphabet is called ________.

  1. Worksheet
  2. Cell
  3. Workbox
  4. Cell Address
  5. Column Address

Answer: (4) Cell Address

Q 2. Where is the option for page border given in the MS Excel spreadsheet?

  1. Home
  2. Insert
  3. Format
  4. View
  5. Page Border cannot be added in excel worksheet

Answer: (5) Page Border cannot be added in excel worksheet

Q 3. Excel workbook is a collection of _______ and _______.

  1. Worksheet and charts
  2. Graphs and images
  3. Sheets and images
  4. Video and audio
  5. None of the above

Answer: (1) Worksheet and charts

Q 4. What type of chart is useful for comparing values over categories?

  1. Bar Graph
  2. Column Chart
  3. Pie Chart
  4. Line Graph
  5. Such charts cannot be created in Excel

Answer: (2) Column Chart

Q 5. There is an option to add comments in an Excel worksheet, what are the cells called in which comments can be added?

  1. Cell Tip
  2. Comment Tip
  3. Smart Tip
  4. Point Tip
  5. Query Tip

Answer: (1) Cell Tip

Q 6. Which of the following symbols needs to be added in the formula bar, before adding a formula?

  1. *
  2. $
  3. %
  4. +
  5. =

Answer: (5) =

Q 7. Which keyboard key is used for Help in MS Excel?

  1. ctrl+H
  2. F2
  3. F1
  4. shift+H
  5. Alt+ctrl+home

Answer: (3) F1

  1. By clicking on it
  2. By pressing the arrow keys
  3. By pressing Tab key
  4. All of the above
  5. None of the above

Q 8. How can you activate a cell in MS Excel?

Answer: (4) All of the above

Q 9. What is the definition of MS Excel?

Ans. MS Excel is a spreadsheet program where one can record data in the form of tables. This gives the user a more systematic display of data.Q2

Q 10. What are the main features of Microsoft Excel?

Ans. The main features of MS Excel include inserting a pivot table, sorting of tabulated data, adding formulas to the sheet, and calculating large data.Q3

Q 11. What are the common MS Excel formulas?

Ans. Given below are the common calculations which can be done using MS Excel:

  • Addition
  • Subtraction
  • Average
  • Maximum and Minimum
  • Concatenate
  • Count

Q 12. What is a cell in Microsoft Excel?

Ans. MS Excel comprises a spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell.Q5

Q 13. Can multiple sheets be added to a single spreadsheet?

Ans. Yes, MS Excel gives an option to add multiple worksheets to a single spreadsheet. The user can rename each of these worksheets as per their requirements.

This content is copied from byjus.com
No comments yet
basic computer computer exceel ms excel

Leave a Reply