MS Excel MCQs

How can you show or hide the grid-lines in Excel worksheet ?

1. Click Gridline tool on Forms toolbar
2. Go to Tools > Options > View tab and mark or remove the check box named Gridline
3. both
4. none

How can you remove boarded applied on cells?

1. Choose None on Border tab of Format cells
2. Open the list on Border tool in Format Cell toolbar then choose first tool
3. Both
4. none

If you need to remove only the formatting done in a range, you must

1. From Edit menu choose Clear and then Formats B. From Edit menu choose Delete C. Click on Remove Formatting tool on Standard Toolbar
2. Click on Remove Formatting tool on Standard Toolbar
3. From Edit menu choose Delete
4. None

It is acceptable to let long text flow into adjacent cells on a worksheet when

1. There is not time to format the text
2. No data will be entered in the adjacent cells
3. Data will be entered in the adjacent cells
4. none

A computer application program that displays data arranged in rows and columns is called?

1. Spreadsheet
2. Register
3. Form
4. Box

Which of the following methods can not be used to edit the contents of a cell?

1. Double clicking the cell
2. Press the Alt key
3. Pressing the F2 key
4. Clicking the formula bar

Which of the following is not a word processor?

1. Word Perfect
2. Microsoft Excel
3. Word Star
4. Microsoft Word

To drag a selected range of data to another worksheet in the same workbook, use the?

1. Shift key
2. Alt key
3. Tab key
4. Ctrl key

MS Excel stands for_______

1. Micromax Excel
2. Microsoft Excel
3. Micromax Excess
4. Management Excel
5. All of these

The .xls extension is used for ___ files

1. Windows
2. Excel
3. Power Point
4. Access
5. Word