Microsoft Excel Trivia Quiz Questions!

40 Questions

Settings
Please wait...
Microsoft Excel Trivia Quiz Questions!


Questions and Answers
  • 1. 
    The Shortcut keyborad for COPY ?
    • A. 

      CTRL+V

    • B. 

      CTRL+P

    • C. 

      CTRL+C

    • D. 

      CTRL+Z

  • 2. 
    The shortcut keyborad to CUT text ?
    • A. 

      CTRL+X

    • B. 

      CTRL+C

    • C. 

      CTRL+V

    • D. 

      CTRL+B

  • 3. 
    The icon in red box is refer to
    • A. 

      Show/Hide Formatting Marks

    • B. 

      Formatting Text

    • C. 

      Remove text effects

    • D. 

      Format Painter

  • 4. 
    The icon in red box is refer to
    • A. 

      Adding text effects

    • B. 

      Format Painter

    • C. 

      Change Text Case

    • D. 

      Remove text effects

  • 5. 
    The type of font 
    • A. 

      Arabstyle

    • B. 

      Arial

    • C. 

      Calibri (Body)

    • D. 

      Calibri

  • 6. 
    How many rows in this table ?
    • A. 

      7

    • B. 

      3

    • C. 

      14

    • D. 

      1

  • 7. 
    The Direction of type 
    • A. 

      From right to left

    • B. 

      From left to right

  • 8. 
    Size of font
    • A. 

      34

    • B. 

      48

    • C. 

      4

    • D. 

      72

  • 9. 
    We apply ........  in text 
    • A. 

      Bold

    • B. 

      Italic

    • C. 

      Underline

    • D. 

      Non Of Above

  • 10. 
    How many number of sheet 
    • A. 

      1

    • B. 

      4

    • C. 

      566

    • D. 

      3

  • 11. 
    The type of view 
    • A. 

      Print layout

    • B. 

      Drift view

    • C. 

      Normal Niew

    • D. 

      Full secreen Reading

  • 12. 
    The orientation apply in page 
    • A. 

      Portrait

    • B. 

      Landscape

  • 13. 
    The extension of any type of word   
    • A. 

      XLSX

    • B. 

      PPX

    • C. 

      DOCX

    • D. 

      PUB

  • 14. 
    When typing text in word you should press ENTER at the end of a: When typing text in word you should press ENTER at the end of a:
    • A. 

      Line

    • B. 

      Page

    • C. 

      Paragraph

    • D. 

      Document

  • 15. 
    To select a single word :
    • A. 

      Press F8 three times

    • B. 

      Press CTRL and click the word

    • C. 

      Press CTRL + W

    • D. 

      Double click the word

  • 16. 
    Which tab would you choose to change the font size of a word from 12 points to 18 points?
    • A. 

      File

    • B. 

      Home

    • C. 

      Insert

    • D. 

      Page Layout

  • 17. 
    If you want to add a table to your document, which tab would you choose?
    • A. 

      File

    • B. 

      Home

    • C. 

      Insert

    • D. 

      Save

  • 18. 
    You insert a clip art and it is too big. To resize it you would.
    • A. 

      Change it the same way you change the font size

    • B. 

      Click the insert tab and choose resize

    • C. 

      Click the Home tab and choose resize

    • D. 

      Click on the clip art to show the handles anddrag a handle to resize it

  • 19. 
    The format of the active part of the document is :
    • A. 

      Page 1 , Sec 1 , 1/1

    • B. 

      Normal , Times New Roman , size 14

    • C. 

      Normal , Times New Roman , size 12

    • D. 

      A+B

  • 20. 
    The name of the document is:
    • A. 

      Computer Skills.doc

    • B. 

      Computer Skills

    • C. 

      Computer Skills.pdf

    • D. 

      Computer Skills.dox

  • 21. 
    The total number of rows in microsoft excel
    • A. 

      24

    • B. 

      1,048,576

    • C. 

      16,384

    • D. 

      155

  • 22. 
    The Range Is select 
    • A. 

      1 cell

    • B. 

      2 cell

    • C. 

      5 cell

    • D. 

      None OF Above

  • 23. 
    How many rows we select
    • A. 

      3 x 3

    • B. 

      3

    • C. 

      6

    • D. 

      4

  • 24. 
    If you see pound signs (#######) in a cell, it means
    • A. 

      The row is very height

    • B. 

      The column is very width

    • C. 

      The number of cell is larg

    • D. 

      The column is not wide enough to display the cell content

  • 25. 
    To unhide a column we 
    • A. 

      Select the columns on Before side of the hidden column

    • B. 

      Select the columns on between side of the hidden column

    • C. 

      Select the columns on either side of the hidden column

    • D. 

      Select the columns on Top side of the hidden column

  • 26. 
    The Type of This Chart is 
    • A. 

      Column

    • B. 

      Line

    • C. 

      Pie

    • D. 

      Par

  • 27. 
    The type of this chart is
    • A. 

      Column

    • B. 

      Pie

    • C. 

      Line

    • D. 

      Par

  • 28. 
     In Excel the intersection of a column and a row is called :
    • A. 

      Range

    • B. 

      Block

    • C. 

      Selection

    • D. 

      Cell

  • 29. 
    What is the shorter way of computing =C1+C2+C3+C4+C5+C6+C7+C8 ?
    • A. 

      TOTAL (C1:C8)

    • B. 

      AVERAGE (C1:C8)

    • C. 

      SUM (C1:C8)

    • D. 

      COUNT (C1:C8)

  • 30. 
    On a Chart, what is used to indicate what each color or symbol stands for ?
    • A. 

      A data series

    • B. 

      The X-axis

    • C. 

      Legend

    • D. 

      A category

  • 31. 
    Writing an incorrect formula that attempts to perform math by referring to a text entry causes excel to display what in the formula cell ?
    • A. 

      ERROR

    • B. 

      #VALUE

    • C. 

      #####

    • D. 

      D.!!!!!

  • 32. 
    How many cells are included in the range A1:B3?
    • A. 

      2

    • B. 

      9

    • C. 

      8

    • D. 

      6

  • 33. 
    Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are
    • A. 

      8,16,32

    • B. 

      2, 4, 2

    • C. 

      2, 2, 2

    • D. 

      6,8,10

  • 34. 
    The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:
    • A. 

      D4+C2*B2

    • B. 

      = (D4+C2*B2

    • C. 

      (D4+C2)*B2

    • D. 

      (B2*(D4+C2)

  • 35. 
    Resulting from this equation 
    • A. 

      0

    • B. 

      777

    • C. 

      10001

    • D. 

      1000

  • 36. 
    Resulting from this equation
    • A. 

      4

    • B. 

      1000

    • C. 

      777

    • D. 

      0

  • 37. 
    Resulting from this equation  
    • A. 

      84

    • B. 

      80

    • C. 

      85

    • D. 

      86

  • 38. 
    Resulting from this ( IF )equation  
    • A. 

      B2=B3

    • B. 

      8=99

    • C. 

      DIV BY ZERO

    • D. 

      NON Of Above

  • 39. 
    Resulting from this equation  
    • A. 

      9

    • B. 

      22

    • C. 

      8

    • D. 

      8/99

  • 40. 
    Resulting from this (IF) equation  
    • A. 

      A2/A3

    • B. 

      " DEV BY ZERO "

    • C. 

      DEV BY ZERO

    • D. 

      66