MS-Excel MCQ Set-4

---

1. The programming language in which Excel keeps the macro code record.
A) Java
B) Visual Basic
C) Basic
D) Video Basic
Answer : B

2. What is the shortcut key to replace in MS-Excel?
A) Ctrl+R
B) Ctrl+E
C) Ctrl+H
D) Ctrl+L
Answer : C

3. Which of the following menu is used for Cut, Copy, Paste, Delete text in Excel?
A) Edit menu
B) File menu
C) Tool menu
D) Format menu
Answer : A

4. The default extension of the Excel file is______
A) .XLS
B) .XLW
C) .WK1
D) .123
Answer : A

5. A worksheet has a header by default-
A) User Name
B) Date and time
C) Sheet tab name
D) None
Answer : D

6. The maximum row in a work sheet is-
A) 256
B) 1024
C) 65536
D) 32000
Answer : C

7. Cell reference will be from range G2 to M12.
A) G2=M12
B) G2;M12
C) G2:M12
D) G2,M12
Answer : C

8. Which menu is used to show and hide the Status Bar in Excel
A) Edit menu
B) File menu
C) View menu
D) Format menu
Answer : C

9. The keyboard shortcut is used to create charts in the selected range.
A) F2
B) F4
C) F8
D) F11
Answer : D

10.  ________ key is used to drag data of range from selected worksheet to another worksheet.
A) Tab
B) Alt
C) Shift
D) Ctrl
Answer : B

11. Which column will you select to insert a new column between Column D and E.
A) select column E
B) select column D
C) select column E , F , G
D) select column D, E , F
Answer : A

12. Which of the following is not the Zoom percentage in excel?
A) 10
B) 100
C) 300
D) 500
Answer : D

13. What is the feature of inserting by dragging number in cells in MS Excel ?
A) Auto Correct
B) Auto Text
C) Auto Fill
D) Auto Cell
Answer : C

14. How many columns are there in Excel?
A) 256
B) 65536
C) 216
D) 220
Answer : A

15. In which menu have Freeze Pane option?
A) Tools
B) Data
C) Window
D) View
Answer : D