Home
MCQs
MS Office MCQs
MS Excel
MS Office MCQs

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

Answer: B

2. Shortcut to underline a text in MS Excel

A. Ctrl+ P

B. Ctrl+ B

C. Ctrl+ U

D. None of above

Answer: C

3. Shortcut key to copy text in MS Excel

A. Ctrl+ P

B. Ctrl+ C

C. Ctrl+ V

D. All of above

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

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

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

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

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

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

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

Answer: C