Top 30 MS Excel MCQ Questions and Answer
1. All formula in Excel start with?
2. Two common wildcard characters that Excel recognizes are-
3. To add two cells (A1 and A2) together you use the following formula
4. You can create hyperlinks from the Excel workbook to
5. The intersection of a row and column is called:
6. The advantage of using a spreadsheet is:
7. If you press ……, the cell accepts your typing as its contents.
8. Which of the following displays the contents of the active cell?
9. What does SUMIF function do?
10. You can insert labels for
11. To open the Format Cells dialog box, press
12. You can add a hyperlink to your worksheet by pressing
13. To move to the previous worksheet, press
14. Excel uses the …. Function when creating a data table
15. You can copy cell formats from one cell to another by using the?
16. What term describes explanatory text attached to a cell?
17. The drag and drop method of copying or moving
18. A value used in a formula that does not change is called a
19. Which function converts miles to kilometers, kilograms to pounds, and so on?
20. You can use the drag and drop method to
21. To access the Go To Special feature, you can press
22. Which do you press to enter the current date in a cell?
23. Which of the following is not an underline option in the format cells dialog box?
24. This type of software contains rows and columns.
25. To open an existing workbook, you can click the Open button on the …… toolbar.
26. To cancel the marquee, press
27. You can activate a cell by
28. Which of the following is not a basic step in creating a worksheet?
29. Which is used to perform what if analysis?
30. Multiple calculations can be made in a single formula using
0 Comments