31st
May
MS Excel MCQ

MS Excel MCQ

  • Admin
  • 31st May, 2022
  • 726 Followers

Take MS Excel MCQ Online Test to test your knowledge 

Practice best MS Excel MCQ test that checks your basic knowledge of MS Excel. This MS Excel MCQ Test contains around 20+ Excel Multple Choice Questions. You have to select the right answer to a question. apart from this, you can also download MS Excel MCQ PDF, completly free.

Also, Read Best MS Excel interview questions.

MS Excel MCQ Quiz

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

  • A. A Dotted Border
  • B.A Dark Wide Border
  • C.A Blinking Border
  • D.By Italic Text

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

  • A. F11
  • B.F10
  • C.F4
  • D.F2

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

  • A. F2
  • B.F1
  • C.F3
  • D.None Of These

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

  • A. Intranet Wizard
  • B.Import Wizard
  • C.Export Wizard
  • D.Internet Assistant Wizard

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

  • A. HTML
  • B.Pivot Table Report
  • C.Pivot Table List
  • D.Pivot Table Field List
Download Free : MS Excel MCQ PDF

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

  • A. F9
  • B.F7
  • C.F6
  • D.F5

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

  • A. 10
  • B.500
  • C.100
  • D.300

8) How Can We Set Page Border In Excel ?

  • A. From Edit Menu
  • B.From Home
  • C.You Can Not Set Page Border In Excel
  • D.From Tools Menu

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

  • A. Ctrl+ :
  • B.Ctrl+ "
  • C.Ctrl+ ;
  • D.Ctrl+T

10) Which Function Calculates Your Monthly Mortage Payment ?

  • A. PMT
  • B.PV
  • C.NPER
  • D.All Of Above

11) Which Types Of Charts Can Excel Produce ?

  • A. Line Graphs And Pie Charts Only
  • B.Bar Charts, Line Graphs And Pie Charts
  • C.Bar Charts And Line Graphs Only
  • D.Only Line Graphs

12) VLOOKUP Function Used To ?

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

13) 3-D Reference In A Formula ?

  • A. Can Not Be Modified
  • B.Spans Worksheets
  • C.Limits The Formatting Options
  • D.Only Appears On Summary Worksheets

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

  • A. Ctrl+ ;
  • B.Ctrl+ "
  • C.Ctrl+ :
  • D.Ctrl+ D

15) To Minimize Workbook In Ms Excel:

  • A. Ctrl+ F8
  • B.Ctrl+ F7
  • C.Ctrl+ F9
  • D.Ctrl+ F6

16) Hyperlinks Can Be In:

  • A. Text
  • B.Pictures
  • C.Drawing Objects
  • D.All Of Above

17) Merge Cells Option Can Be Applied From ?

  • A. Formatting Toolbar
  • B.Format Cells Dialog Box Alignment Tab
  • C.Both Of Above
  • D.None Of Above

18) We Can Cancel Marquee By Pressing ?

  • A. Ctrl + Esc
  • B.Alt + Esc
  • C.Shift + Esc
  • D.Esc

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

  • A. COUNT
  • B.NUM
  • C.SUM
  • D.CHKNUM

20) Which one is not a function in ms excel?

  • A. SUM
  • B.AVG
  • C.MAX
  • D.MIN

21) Which of the following key is Used for help In Ms Excel?

  • A. F1
  • B.F2
  • C.F3
  • D.None of the above

22) Which of the following key is used to "Goto" tab In Ms Excel?

  • A. F5
  • B.F6
  • C.F7
  • D.F9

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

  • A. Graphs
  • B.Charts
  • C.Tables
  • D.All of the above

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

  • A. Sheet
  • B.Workbook
  • C.Worksheet
  • D.Spreadsheet

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.