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:
How to Start Excel
Starting the Excel is too easy.
You just need to follow the given steps:
Formula auditing is simple.
You just need to go with all the steps mentioned below.
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
To protect the structure of your workbook, follow these steps:
To share them, follow the mentioned steps carefully.
This also allows workbook/ worksheet merging checkbox on the Editing tab.
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.
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
