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. VLOOKUP Function Used To ?
  13. 3-D Reference In A Formula ?
  14. Which Of These Keys Are Used In Ms Excel To Copy Value From Above Cell?
MS Excel MCQ

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.

  • A Dotted Border
  • A Dark Wide Border
  • A Blinking Border
  • By Italic Text
View Answer
  • Intranet Wizard
  • Import Wizard
  • Export Wizard
  • Internet Assistant Wizard
View Answer
  • HTML
  • Pivot Table Report
  • Pivot Table List
  • Pivot Table Field List
View Answer
  • From Edit Menu
  • From Home
  • You Can Not Set Page Border In Excel
  • From Tools Menu
View Answer
  • Line Graphs And Pie Charts Only
  • Bar Charts, Line Graphs And Pie Charts
  • Bar Charts And Line Graphs Only
  • Only Line Graphs
View Answer
  • Finds Related Records
  • Looks Up Text That Contain "v"
  • Check If Two Cells Are Identical
  • None Of Above
View Answer
  • Can Not Be Modified
  • Spans Worksheets
  • Limits The Formatting Options
  • Only Appears On Summary Worksheets
View Answer
  • Ctrl+ F8
  • Ctrl+ F7
  • Ctrl+ F9
  • Ctrl+ F6
View Answer
  • Text
  • Pictures
  • Drawing Objects
  • All Of Above
  • Formatting Toolbar
  • Format Cells Dialog Box Alignment Tab
  • Both Of Above
  • None Of Above
View Answer
  • Ctrl + Esc
  • Alt + Esc
  • Shift + Esc
  • Esc
  • COUNT
  • NUM
  • SUM
  • CHKNUM
View Answer
  • SUM
  • AVG
  • MAX
  • MIN
View Answer