MCQ Sets

MS Excel MCQ Questions Quiz Set 04

by 7 Comments

Get another set of MCQ Questions in this Excel Quiz 04. Prepare you competitive exam with our hand picked multiple choice questions and I believe this MS Excel MCQ Questions will help to make you sharper and more competent.

MS Excel MCQ Quiz 04

1. “Qtr 1,  Qtr 2,  Qtr 3” is an example of a
 
 
 
 
2. What is the shortcut key to insert current date in a cell?
 
 
 
 
3. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
 
 
 
 
4. To center worksheet titles across a range of cells, you must
 
 
 
 
5. The autofill feature
 
 
 
 
6. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
 
 
 
 
7. Hyperlinks cannot be
 
 
 
 
8. Which of the following is not an option in the spelling dialog box?
 
 
 
 
9. How do you change column width to fit the contents?
 
 
 
 
10. Microsoft Excel is a powerful………..
 
 
 
 
11. What should be add before a fraction to avoid entering it as a date?
 
 
 
 
12. An excel workbook is a collection of
 
 
 
 
13. You can activate a cell by
 
 
 
 
14. You can activate a cell by
 
 
 
 
15. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
 
 
 
 
16. Which is used to perform what if analysis?
 
 
 
 
17. To copy cell contents using drag and drop, press the
 
 
 
 
18. What does COUNTA () function do?
 
 
 
 
19. Which of the following format you can decide to apply or not in AutoFormat dialog box?
 
 
 
 
20. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
 
 
 
 

 

Please note that, I’ve tried my level best to make MS Excel MCQ Quiz free from mistakes and errors. However, if you notice something wrong, please let me know through comment form below (or you can email me using Contact Us page). While commenting or contacting me, please, copy and paste the question itself. Mere question number can’t help me identify it because these are 20 Excel MCQs out of the 400+ MCQ bank.

Comments

  1. 16. The spelling tool is placed on ______ toolbar

    Standard
    Formatting
    Drawing
    Reviewing
    Confuse Sir, A and D

    Reply

  3. In mcq bank for ms excel pdf.. The answer for the que. In a worksheet you can press shift +space to select entire …….. Is d. Worksheet, row , column…

    And here it shows b. rows

    Reply

  4. when you insert an excel file into word document. the data are..
    a) linked
    b) embedded
    c) use the word menu bar and toolbars

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments