MCQ Sets

MS Excel MCQ Quiz – Set 02

Published:

Enjoy the second set of Microsoft Excel online MCQ quiz!

Microsoft Excel MCQ Quiz

1. In order to perform a calculation in a spreadsheet, you need to use a:
 
 
 
 
2. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
 
 
 
 
3. You can use the formula palette to
 
 
 
 
4. How do you select an entire column?
 
 
 
 
5. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
 
 
 
 
6. Except for the …… function, a formula with a logical function shows the word "TRUE"" or ""FALSE"" as a result"
 
 
 
 
7. When integrating Ms-Word and Excel, Word is usually the
 
 
 
 
8. In a worksheet you can select
 
 
 
 
9. Which of the following is correct?
 
 
 
 
10. Which one is the last column header in Excel 2007?
 
 
 
 
11. How do you display current date and time in MS Excel?
 
 
 
 
12. A circular reference is
 
 
 
 
13. Which of the following will not cut information?
 
 
 
 
14. When you want to insert a blank imbedded excel object in a word document you can
 
 
 
 
15. What is the shortcut key to insert a new comment in a cell?
 
 
 
 
16. MS-EXCEL is based on ……….?
 
 
 
 
17. When you insert an Excel file into a Word document, the data are
 
 
 
 
18. How are data organized in a spreadsheet?
 
 
 
 
19. "New Comment"" option can be found under _________ tab"
 
 
 
 
20. A typical worksheet has …. Number of columns
 
 
 
 

 

I’ve paid my utmost care to make this MS Excel MCQ Quiz error free. However, if you discover any error or mistake please copy and paste the question in the comment box below. Simply the question number won’t help me identify it because the questions are dynamically generated. You are presented only 20 questions from the set of 400+ Microsoft Excel MCQ Questions bank.

Comments

  1. 16. To insert three columns between columns D and E you would
    Select column D
    Select column E
    Select columns E, F and G
    Select columns D, E, and F.
    CORRECT ANSWER MAY BE C) Select column E,F and G BUT HERE DISPLAY B) Select Column E IS CORRECT.
    B) Select column E is correct answer or not..?
    Plz….. Clear ..

    Reply

  2. हार्दिक धन्यवाद सर,
    Clear गरिदिनु भएकोमा ।

    Reply

  3. In MCQ Quize it displays…
    ——————————–
    Which is not the function of “Edit
    Clear”” command?”
    Delete contents
    Delete notes
    Delete cells

    But it should be……..
    ———————————————————
    Which is not the function of “Edit, Clear” command?
    a. Delete contents
    b. Delete notes
    c. Delete cells
    d. Delete formats

    Reply

  4. Deat MCQ Sets ! Namaste .

    5. How to restrict to run a macro automatically when starting Microsoft Excel?
    Hold down the SHIFT key during startup
    Hold down the CTRL key during startup
    Hold down the ESC key during startup
    Hold down the ALT key during startup

    answer display “Hold down the SHIFT key during startup”
    which is correct answer for this questions …?

    i thinks correct answer is “Hold down the ESC key during startup”

    Reply

  5. The Delete key of keyboard is assigned to which command in Excel?

    Edit >> Clear >> Contents
    Edit >> Clear >> All
    Edit >> Delete
    All of above
    Answer is All of above isn’t sir. please help me

    Reply

Leave a Reply

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

Recent Comments