MS Excel MCQ Quiz

Take MS Excel Quiz To test your Knowledge 

Below are few MS Excel MCQ test that checks your basic knowledge of MS Excel. This MS Excel 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
View Answer

2. Which Of The Following Keyboard Shortcut Can Be Used For Creating A Chart From The Selected Cells ?

  • F11
  • F10
  • F4
  • F2

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
View Answer

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
View Answer

6. Which Key Is Used To "Goto" Tab In Ms Excel?

  • F9
  • F7
  • F6
  • F5

7. Which Of The Following Is Not A Valid Zoom Percentage In Excel ?

  • 10
  • 500
  • 100
  • 300

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
View Answer

9. Which Of These Keys Are Used In Ms Excel To Insert Current Time In Workbook?

  • Ctrl+ :
  • Ctrl+ "
  • Ctrl+ ;
  • Ctrl+T
View Answer

10. Which Function Calculates Your Monthly Mortage Payment ?

  • PMT
  • PV
  • NPER
  • All Of Above

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
View Answer

12. VLOOKUP Function Used To ?

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

13. 3-D Reference In A Formula ?

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

14. Which Of These Keys Are Used In Ms Excel To Copy Value From Above Cell?

  • Ctrl+ ;
  • Ctrl+ "
  • Ctrl+ :
  • Ctrl+ D
View Answer

15. To Minimize Workbook In Ms Excel:

  • Ctrl+ F8
  • Ctrl+ F7
  • Ctrl+ F9
  • Ctrl+ F6
View Answer

16. Hyperlinks Can Be In:

  • Text
  • Pictures
  • Drawing Objects
  • All Of Above

17. Merge Cells Option Can Be Applied From ?

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

18. We Can Cancel Marquee By Pressing ?

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

Write For Us.

Contribute the Community.