Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. C ++
D. Java
Answer
Correct Answer: A. Visual Basic
How many sheets are there in Excel Workbook by default?
A. 2
B. 4
C. 3
D. 5
Answer
Correct Answer: C. 3
In MS-Excel, which shortcut key is used to edits the selected cell?
A. F1
B. F2
C. F3
D. F4
Answer
Correct Answer: B. F2
In MS-Excel, which shortcut key is used to creates a formula to sum all of the above cells?
A. Alt+Tab
B. Alt+Spacebar
C. Alt+=
D. Alt+’
Answer
Correct Answer: C. Alt+=
In MS-Excel, which shortcut key is used to opens the system menu?
A. Alt+Tab
B. Alt+Spacebar
C. Alt+=
D. Alt+’
Answer
Correct Answer: B. Alt+Spacebar
In MS-Excel, which shortcut key is used to cycles through applications?
A. Alt+Tab
B. Alt+Spacebar
C. Alt+=
D. Alt+’
Answer
Correct Answer: A. Alt+Tab
In MS-Excel, which shortcut key is used to extends the highlighted area right one character?
A. Shift+Up Arrow
B. Shift+Down Arrow
C. Shift+Left Arrow
D. Shift +Right Arrow
Answer
Correct Answer: D. Shift +Right Arrow
In MS-Excel, which shortcut key is used to extends the highlighted area left one character?
A. Shift+Up Arrow
B. Shift+Down Arrow
C. Shift+Left Arrow
D. Shift +Right Arrow
Answer
Correct Answer: C. Shift+Left Arrow
In MS-Excel, which shortcut key is used to extends the highlighted area down one cell?
A. Shift+Up Arrow
B. Shift+Down Arrow
C. Shift+Left Arrow
D. Shift +Right Arrow
Answer
Correct Answer: B. Shift+Down Arrow
In MS-Excel, which shortcut key is used to extends the highlighted area up one cell?
A. Shift+Up Arrow
B. Shift+Down Arrow
C. Shift+Left Arrow
D. Shift +Right Arrow
Answer
Correct Answer: A. Shift+Up Arrow