Alert: You are not allowed to copy content or view source
Check Olympiad Exam Dates here | Buy Practice Papers for CREST Olympiads here | Individual Registration will close soon on CREST Olympiads. Apply now | Login here to participate in all India free mock test on every Saturday

MS-Excel 2010

MS-Excel 2010

Lets’ learn about MS Excel 2010 today. 

Introduction to MS Excel 2010

MS Excel 2010 is a spreadsheet program that contains rows, columns, charts, graphs, mathematical functions and formatting tools.

It is used for a number of reasons:

  1. Data of large data set can be compiled easily.
  2. Due to several inbuilt functions calculations becomes easier.
  3. Data can be represented in an attractive manner; charts and graphs.
  4. The accuracy of the result is maximum.
  5. Re-entry of the data can be done easily; thus making every work easier.

How to Start Excel

Starting the Excel is too easy.

You just need to follow the given steps:

  1. Click the Start button.
  2. Click All Programs.
  3. Select MS Office-> MS Excel
  4. MS Excel sheet will open.

Formula Auditing

Formula auditing is simple.

You just need to go with all the steps mentioned below.

  1. Select the formula which you want to audit.
  2. Click the Formulas tab in the Office Ribbon.
  3. As soon you click the Trace Precedents tool for a selected cell (containing a formula). A set of arrows will appear pointing to the cell. These arrows indicate all of the cells for the selected cell. This helps you determine where the values that make up your formula come originally from.
  4. The Trace Dependents tool tells you which cells rely on or are dependent on the selected cell. This is a great tool going through a 
    spreadsheet deleting unnecessary information, it can help you determine which cells matter and which do not.
  1. You can use Remove Arrows button to remove arrows which you found clutter in the spreadsheet.

  2. Select which arrows you wish to remove.
  3. When you click on the Show Formulas button. the cells containing formulas will be displayed.
  1. To ensure all formulas you are using are correct, click on the Error Checking button.
  2. When the Error Checking window opens you will be able to locate any formulas with errors. 
  1. Even you can evaluate the formula step-by-step. By a click on the cell containing the formula, you want to evaluate.
  2. Click on the Evaluate Formula button. 
    A window will open where you evaluate as per your choice.

Data Tools in Excel 2010

Data Tools in Microsoft Excel are simply tools which are used to manipulate the data in an easy way. Some of them are intended to save your time by extracting or joining data and others perform complex calculations with just a click.

How to open data tools in MS Excel 2010

  1. Open MS Excel 2010
  2. Open Excel Options from Excel 2010 ribbon if you do not have Classic Menu for Office.
  3. Click the File tab.
  4. View the Options button at left bar.
  5. Click it into Excel Options window. Your data tools will open up.

Protecting and Sharing Workbooks/Worksheets  

To protect the structure of your workbook, follow these steps: 

  1. Click Review
  2. Protect Workbook/worksheet (Select what you want to be protected)
  3. Enter a password in the Password box
  4. In Excel for Windows, click OK, and retype the password to confirm it.
  5. And, then click OK.

How to share Workbooks/Worksheets

To share them, follow the mentioned steps carefully.

  1. Select the "Review" tab.
  2. You can click the "Share Workbook" command in the Changes section available on the ribbon. The Share Workbook dialog box opens up to you.
  3. Check the box next to "Allow Changes by More Than One User at the Same Time."
  4. Your workbook/worksheet is shared.

This also allows workbook/ worksheet merging checkbox on the Editing tab.

Working with cell range

A group of cells can be selected by dragging the mouse over them holding down the left button. Or the range of the cell can be selected with the help of a keyboard.

    Questions

  1. What is MS Excel 2010?
  2. List the number of reasons for using MS Excel.
  3. How to start MS Excel?
  4. What is auditing formula? Write the steps.
  5. Write a short note on data tools in Excel 2010.
  6. How to protect the structure of the workbook?
  7. How to share workbook/worksheet?
  8. Write a short note on working with cell range.

Recap

  • MS Excel 2010; Introduction.
  • MS Excel importance.
  • How to start MS Excel 2010.
  • Auditing Formula; Basic steps.
  • Data tools in Excel 2010.
  • Protecting and sharing workbooks/worksheets
  • Working with cell range

Quiz for MS-Excel 2010

Q.1

Which of the following methods is not used to enter data in the cell?

a) Press Esc
b) Press Tab
c) Press Enter
d) Use any arrow key

Q.2

How will you select an entire row at once?

a)

Press Ctrl + A

b)

Hold down alt key till your desired column

c)

Hold down enter key

d)

Select the row header

Q.3

How will you insert a formulae in your worksheet?

a) Select the Insert Tab.
b) By pressing Ctrl + F
c) By clicking Formulae tab, and selecting your formulae
d) By right clicking on the cell, and selecting Formal cell option

Q.4

To create a formulae what will you do first?

a) Select the column you want to insert the formulae into.
b) Use Formulae tab.
c) Choose Save command from file option
d) Press (=) and then insert the formulae

Q.5

How will you merge a range of cells?

a) Ctrl + Shift + M
b) Ctrl + M
c) Select the cells you want to merge and right click and select format cell
d) Select the cells you want to merge, and select Merge cells options.

Q.6

The Name Box?

a) Shows the format of your cell
b) Shows data of your cell
c) Is above the status bar
d) Shows the cell you are currently in

Q.7

What do you use to add up a series of numbers?

a) Sort and Filter Button
b) Formulae Button
c) Auto-Sum Button
d) Clear Button

Q.8

How do you insert a new worksheet in the same workbook?

a) Shift + Del
b) Shift + F
c) Ctrl + F
d) Shift + F11

Q.9

With which symbol does all formulae must begin with?

a) =
b) (
c) @
d) -

Q.10

Using what before the number can you make a number a label?

a) Double Quotes
b) Equal
c) Underscore
d) Apostrophe

Your Score: 0/10

Other Chapters of Class 9

  EXPLORE  

70%