1
|
The programming language in which Excel keeps the macro code
record.
|
|
(A) Java
|
|
(B) Visual Basic
|
|
(C) Basic
|
|
(D) Video Basic
|
|
2
|
What is the shortcut key to replace in MS-Excel?
|
|
(A) Ctrl+R
|
|
(B) Ctrl+E
|
|
(C) Ctrl+H
|
|
(D) Ctrl+L
|
|
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
|
|
4
|
The default extension of the Excel file is______
|
|
(A) .XLS
|
|
(B) .XLW
|
|
(C) .WK1
|
|
(D) .123
|
|
5
|
A worksheet has a header by default-
|
|
(A) User Name
|
|
(B) Date and time
|
|
(C) Sheet tab name
|
|
(D) None
|
|
6
|
The maximum row in a work sheet is-
|
|
(A) 256
|
|
(B) 1024
|
|
(C) 65536
|
|
(D) 32000
|
|
7
|
Cell reference will be from range G2 to M12.
|
|
(A) G2=M12
|
|
(B) G2;M12
|
|
(C) G2:M12
|
|
(D) G2,M12
|
|
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
|
|
9
|
The keyboard shortcut is used to create charts in the selected
range.
|
|
(A) F2
|
|
(B) F4
|
|
(C) F8
|
|
(D) F11
|
|
10
|
________ key is used to drag data of range from selected
worksheet to another worksheet.
|
|
(A) Tab
|
|
(B) Alt
|
|
(C) Shift
|
|
(D) Ctrl
|
|
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
|
|
12
|
Which of the following is not the Zoom percentage in excel?
|
|
(A) 10
|
|
(B) 100
|
|
(C) 300
|
|
(D) 500
|
|
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
|
|
14
|
How many columns are there in Excel?
|
|
(A) 256
|
|
(B) 65536
|
|
(C) 216
|
|
(D) 220
|
|
15
|
In which menu have Freeze Pane option?
|
|
(A) Tools
|
|
(B) Data
|
|
(C) Window
|
|
(D) View
|
|
0 Comments