MS Office MCQs - MS Excel
MS Excel MCQs consist of Shortcut Keys, Functions, Formulas, Sheets, Workbook, Data Formatting, Charts, Graphs, Lines, Tables and Layouts.
1. A key is used to edit current cell?
A. F1
B. F2
C. F5
D. F6
View Answer
Answer: B
2. Shortcut to underline a text in MS Excel
A. Ctrl+ P
B. Ctrl+ B
C. Ctrl+ U
D. None of above
View Answer
Answer: C
3. Shortcut key to copy text in MS Excel
A. Ctrl+ P
B. Ctrl+ C
C. Ctrl+ V
D. All of above
View Answer
Answer: B
4. A ShortCut key to close the workbook in MS Excel
A. Ctrl+ C
B. Ctrl+ W
C. Ctrl+ X
D. None of These
View Answer
Answer: B
5. A key to open new workbook in MS Excel
A. Ctrl + N
B. Ctrl+ B
C. Ctrl+ W
D. None of these
View Answer
Answer: A
6. What is difference between Formulas and Functions in MS Excel?
A. Formula is an expression
B. Functions are predefined formulas
C. A and B
D. None of above
View Answer
Answer: C
7. =SUM(B2:G2)
A. A simple selection that sums the values of a row.
B. A simple selection that sums the values of a column
C. A and B
D. None of Above
View Answer
Answer: A
8. An AVERAGE Function is used in MS Excel for
A. To calculate the average
B. To sum of rows
C. To give the range of values
D. All of above
View Answer
Answer: A
9. A key to bold all cells in the highlighted section
A. Ctrl+A
B. Ctrl+A+B
C. Ctrl+B
D. None of these
View Answer
Answer: C
10. A ShortCut key to fill Content of the selected cell on top to bottom.
A. Ctrl+ V
B. Ctrl + M
C. Ctrl+ D
D. All of above
View Answer
Answer: C