Ms Excel Mcq Pdf Free Download

MS Excel MCQ Quiz

1. On An Excel Sheet The Active Cell In Indicated By ?
2. Which Of The Following Keyboard Shortcut Can Be Used For Creating A Chart From The Selected Cells ?
3. Which Key Is Used For Help In Ms Excel?
4. You Can Convert Existing Excel Worksheet Data And Charts To HTML Document By Using The ?
5. To Create An Interactive Pivot Table For The Web, You Use A Microsoft Office Web Component Called ?
6. Which Key Is Used To "Goto" Tab In Ms Excel?
7. Which Of The Following Is Not A Valid Zoom Percentage In Excel ?
8. How Can We Set Page Border In Excel ?
9. Which Of These Keys Are Used In Ms Excel To Insert Current Time In Workbook?
10. Which Function Calculates Your Monthly Mortage Payment ?
11. Which Types Of Charts Can Excel Produce ?
12. 3-D Reference In A Formula ?
13. Which Of These Keys Are Used In Ms Excel To Copy Value From Above Cell?
14. To Minimize Workbook In Ms Excel:

Last Updated: May 05, 2021,

Posted in Interview Questions,

24 Questions

Take MS Excel MCQ Online Test to test your knowledge

Below are fewMS Excel MCQ test that checks your basic knowledge of MS Excel. ThisMS Excel MCQ Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best MS Excel interview questions.

1. On An Excel Sheet The Active Cell In Indicated By ?

• A Dotted Border
• A Dark Wide Border
• A Blinking Border
• By Italic Text

3. Which Key Is Used For Help In Ms Excel?

• F2
• F1
• F3
• None Of These

4. You Can Convert Existing Excel Worksheet Data And Charts To HTML Document By Using The ?

• Intranet Wizard
• Import Wizard
• Export Wizard
• Internet Assistant Wizard

5. To Create An Interactive Pivot Table For The Web, You Use A Microsoft Office Web Component Called ?

• HTML
• Pivot Table Report
• Pivot Table List
• Pivot Table Field List

8. How Can We Set Page Border In Excel ?

• From Edit Menu
• From Home
• You Can Not Set Page Border In Excel
• From Tools Menu

11. Which Types Of Charts Can Excel Produce ?

• Line Graphs And Pie Charts Only
• Bar Charts, Line Graphs And Pie Charts
• Bar Charts And Line Graphs Only
• Only Line Graphs

12. 3-D Reference In A Formula ?

• Can Not Be Modified
• Spans Worksheets
• Limits The Formatting Options
• Only Appears On Summary Worksheets

14. To Minimize Workbook In Ms Excel:

• Ctrl+ F8
• Ctrl+ F7
• Ctrl+ F9
• Ctrl+ F6

15. Merge Cells Option Can Be Applied From ?

• Formatting Toolbar
• Format Cells Dialog Box Alignment Tab
• Both Of Above
• None Of Above

16. We Can Cancel Marquee By Pressing ?

• Ctrl + Esc
• Alt + Esc
• Shift + Esc
• Esc

17. VLOOKUP Function Used To ?

• Finds Related Records
• Looks Up Text That Contain "v"
• Check If Two Cells Are Identical
• None Of Above

18. Hyperlinks Can Be In:

• Text
• Pictures
• Drawing Objects
• All Of Above

19. _______________functionin Excel tells how many numeric entries are there.

• COUNT
• NUM
• SUM
• CHKNUM

View Answer

COUNT functionin Excel tells how many numeric entries are there.

23. Worksheet data can be viewed in forms of .................

• Graphs
• Charts
• Tables
• All of the above

24. An excel file is generally called a ...............

• Sheet
• Workbook
• Worksheet
• Spreadsheet

Posted by: bryantbryantparettie0268141.blogspot.com

Source: https://www.onlineinterviewquestions.com/ms-excel-mcq/