1. : Which method cannot be used to enter data in a cell?
(A) Pressing an arrow key
(B) Pressing the Esc key
(C) Pressing the Tab key
(D) Clicking on the formula bar
2. : Which key is used to format number in time format in Excel?
(A) Ctrl + Shift + 2
(B) Ctrl + Shift + 3
(C) Ctrl + Shift + 5
(D) Ctrl + Shift + 2
3. : Which key is used to format number in scientific format in Excel?
(A) Ctrl + Shift + 5
(B) Ctrl + Shift + 3
(C) Ctrl + Shift + 6
(D) Ctrl + Shift + 4
4. : Which key is used to format number in percentage format in Excel?
(A) Ctrl + Shift + 5
(B) Ctrl + Shift + 3
(C) Ctrl + Shift + 6
(D) Ctrl + 1
5. : Which key is used to format number in date format in Excel?
(A) Ctrl + Shift + 3
(B) Ctrl + Shift + 4
(C) Ctrl + Shift + 6
(D) Shift + 1
6. : Which key is used to format number in currency format in Excel?
(A) Ctrl + Shift + 4
(B) Ctrl + Shift + 1
(C) Ctrl + 1
(D) Shift + 1
7. : Which key is used to format number in comma format in Excel?
(A) Shift + 1
(B) Ctrl + Shift + 4
(C) Ctrl + 1
(D) Ctrl + Shift + 1
8. : Which key is used to create a formula to sum all of the above cells in Excel?
(A) Alt + =
(B) Alt + –
(C) Ctrl + =
(D) Ctrl + –
9. : Which key is used to open the formula dialog box in Excel?
(A) Shift + F3
(B) Shift + F6
(C) Alt + Shift + F3
(D) Alt + Shift + F6
10. : Which key is used to insert a new worksheet in Excel?
(A) Alt + Shift + F1
(B) Alt + F1
(C) Alt + F2
(D) Alt + Shift + F2
11. : Which key is used to find in Excel?
(A) Ctrl + F
(B) Ctrl + C
(C) Alt + Shift + D
(D) Alt + Shift + F
12. : Which key is used to create a chart from selected data in Excel?
(A) F10
(B) F1
(C) F11
(D) Both A & B
13. : Which key is used to open the Format Cells window in Excel?
(A) Ctrl + 1
(B) Ctrl + 6
(C) Ctrl + F1
(D) Ctrl + F10
14. : Which key is used to edit the selected cell in Excel?
(A) F4
(B) F2
(C) F10
(D) Edit
15. : Which key is used to enter the current date in Excel?
(A) Ctrl + ;
(B) Ctrl + :
(C) Ctrl + Shift + :
(D) Ctrl + Shift + ;
16. : Which key is used to select an entire row in Excel?
(A) Shift + Space
(B) Ctrl + Space
(C) Alt + Space
(D) None of these
17. : Which key is used to select the entire column in Excel?
(A) Shift + Space
(B) Ctrl + Space
(C) Alt + Space
(D) None of these
18. : Which shortcut key is used to quit Microsoft Word, PowerPoint, Access, Excel etc.?
(A) Shift + F4
(B) Ctrl + W
(C) Alt + F4
(D) Alt + W
19. : Which key is used to display the active cell in Excel?
(A) Shift + Backspace
(B) Alt + Backspace
(C) Ctrl + Backspace
(D) None
20. : What is the comment put on Excel cell which is displayed by taking the mouse pointer there known as?
(A) Cell Tip
(B) Soft Tip
(C) Web Tip
(D) Smart Tip
21. : Which menu is used in MS Excel to delete duplicate values?
(A) Formatting
(B) Tools
(C) Data
(D) Layout
22. : How many rows are there in one Microsoft Excel sheet?
(A) 16,384
(B) 65,536
(C) 1,048,576
(D) None of the Above