MS EXCEL MCQ Questions and Answers for Practice

1. What is the short cut key to highlight the entire column ?

1. None of the above
2. Ctrl + Space Bar
3. Ctrl + Enter
4. Ctrl + Right Arrow key

2. How do you rearrange the data in ascending or descending order ?

1. None of the above
2. Data, Sort
3. Data, Form
4. Data, Table

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

1. None of the above
2. Date
3. Text
4. Fraction

4. How do you display current date and time in MS Excel?

1. time ()
2. date ()
3. Today ()
4. now ()

5. How do you display current date only in MS Excel?

1. time ()
2. date ()
3. Today ()
4. now ()

6. Formatting a cell in Currency, you can specify

1. None of the above
2. Decimal Places
3. Currency Symbol
4. Percentage symbol

7. Which is not the function of “Edit, Clear” command?

1. Delete formats
2. Delete contents
3. Delete notes
4. Delete cells

8. Which of the following is not an underline option in the format cells dialog box?

1. Single Engineering
2. Double
3. Single Accounting
4. Double Accounting

9. Comments can be added to cells using

1. View –> Comments
2. Edit -> Comments
3. Insert -> Comment
4. File -> Comments

10. Which would you choose to create a bar diagram?

1. Format, Chart
2. Edit, Chart
3. Insert, Chart
4. Tools, Chart

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

1. Apply the Text format in the cell and type the numbers
2. Enclose the number is brackets
3. Place the character T before the number
4. Place the character TX before the number

12. Which of the following shortcuts can be used to insert a new line in the same cell?

1. Shift + Enter
2. Enter
3. Alt + Enter
4. Ctrl + Enter

13. An Excel file is generally called a / an :

1. Sheet
2. E-Spreadsheet
3. Woorksheet
4. Workbook

14. Which of the following is the oldest spreadsheet package ?

1. None of the above
2. Excel
3. StarCalc
4. VisiCalc

15. Which key do you press to check spelling?

1. F9
2. F3
3. F5
4. F7