Microsoft Word And Excel Final

38 Questions

Settings
Please wait...
Microsoft Word Quizzes & Trivia

Microsoft word and excel are two of the most used computer applications by computer users. Most people have a hard time when it comes to using excel. This final exam will test your knowledge gained from MS Word and Excel. Take up the quiz below and get to find out just how much you know about using them and the vocabulary used in each.


Questions and Answers
  • 1. 
    Which of the following is word processing software?
    • A. 

      Microsoft Word

    • B. 

      Microsoft Excel

    • C. 

      Microsoft Internet Explorer

    • D. 

      Microsoft Windows Explorer

  • 2. 
    Where should you save your computer files.
    • A. 

      On the desktop

    • B. 

      On your flash drive or personal account

    • C. 

      Anywhere you like.

  • 3. 
    When the text automatically goes onto the next line this is called
    • A. 

      Page wrap

    • B. 

      Page wrap

    • C. 

      Word wrap

    • D. 

      Text wrapping

  • 4. 
    When entering in a lot of text in capitals you should use the
    • A. 

      Enter key

    • B. 

      Big letter key

    • C. 

      All caps key

    • D. 

      Caps lock key

  • 5. 
    Left justify is the same as
    • A. 

      Align over one space

    • B. 

      Align next

    • C. 

      Align left

    • D. 

      Align all

  • 6. 
    The steps to place a page break into a document are....
    • A. 

      Right click, insert break

    • B. 

      On the menu bar click insert, break, page break, click ok

    • C. 

      Click in front of the paragraph and hit enter until it reaches the next page.

  • 7. 
    To move the text to the right side of the page you would use....
    • A. 

      Align left

    • B. 

      Align over one space

    • C. 

      Align right

    • D. 

      Align top

  • 8. 
    To save a file under a different name you should use....
    • A. 

      Save as

    • B. 

      Save

    • C. 

      Save all

    • D. 

      Save new

  • 9. 
    • A. 

      You are in the middle of a document

    • B. 

      You are at the end of the document

    • C. 

      You are starting a new paragraph

  • 10. 
    To send the same document addressed to 10 different people you should use
    • A. 

      Multiple merge

    • B. 

      Mail merge

    • C. 

      Merge

  • 11. 
    To ensure that you do not lose all of your files you should always make a
    • A. 

      Back up copy

    • B. 

      Back down

    • C. 

      Back over

    • D. 

      Back under

  • 12. 
    To control where a page should end, you can always insert a
    • A. 

      Hard page break

    • B. 

      End page break

    • C. 

      Merge page break

  • 13. 
    In addition to using a spell checker you should also always
    • A. 

      Ignore any mistakes because spellcheck will catch all of them.

    • B. 

      Proofread your papers

    • C. 

      Press read your papers.

  • 14. 
    Landscape mode is when the paper is
    • A. 

      Taller than it is wider

    • B. 

      Wider than it is taller

    • C. 

      Smaller than normal

    • D. 

      Bigger than normal

  • 15. 
    The ____ is an area in the top margin of each page in a document where you can insert text or graphics.
    • A. 

      Headnote

    • B. 

      Top margin

    • C. 

      Footer

    • D. 

      Header

  • 16. 
    The default font in Word is
    • A. 

      Arial

    • B. 

      Comic Sans MS

    • C. 

      Times New Roman

    • D. 

      Courier

  • 17. 
    To find alternative words with the same/similar meaning use the
    • A. 

      Spell checker

    • B. 

      Thesaurus

    • C. 

      Grammar Checker

    • D. 

      Editor

  • 18. 
    To move a block of text you would use...
    • A. 

      Cut and copy

    • B. 

      Copy and paste

    • C. 

      Cut and paste

    • D. 

      Move block

  • 19. 
    Before copying text you must first....
    • A. 

      Move the text

    • B. 

      Delete the text

    • C. 

      Highlight the text

    • D. 

      Copy the text

  • 20. 
    To see how a spreadsheet will print out, you should use
    • A. 

      Page overview

    • B. 

      Page preview

    • C. 

      Page break

    • D. 

      Look at the page

  • 21. 
    In Excel, what is the following symbol used for in a formula.... *
    • A. 

      Subtracting

    • B. 

      Dividing

    • C. 

      Multiplying

    • D. 

      Adding

  • 22. 
    In Excel, what is the following symbol used for in a formula.... +
    • A. 

      Multiplying

    • B. 

      Dividing

    • C. 

      Adding

    • D. 

      Subtracting

  • 23. 
    In Excel, what is the following symbol used for in a formula.... /
    • A. 

      Division

    • B. 

      Multiplying

    • C. 

      Adding

    • D. 

      Subtracting

  • 24. 
    If cell A1 has the formula =2*6, what is displayed in the cell?
    • A. 

      -4

    • B. 

      8

    • C. 

      12

    • D. 

      26

  • 25. 
    If cell A1 has the formula =6/2, what is displayed in the cell?
    • A. 

      12

    • B. 

      4

    • C. 

      3

    • D. 

      6

  • 26. 
    What are the steps to changing the tab color in a spreadsheet?
    • A. 

      Right click on the sheet, select the color and click ok

    • B. 

      Right click on the menu bar, select the color and click yes

    • C. 

      Right click on the sheet tab, select tab color, select the color, click ok

    • D. 

      Right click and select the color.

  • 27. 
    Which of the following is formatted to 2 decimal places?
    • A. 

      26

    • B. 

      .26

    • C. 

      26.00

    • D. 

      26.000

  • 28. 
    True or false...The SUM function allows to calculate numbers much faster.
    • A. 

      False, it actually takes much longer to use the SUM function

    • B. 

      True, this is much quicker than creating formulas from scratch.

  • 29. 
    When you save an Excel workbook, what is the extension at the end of the filename?
    • A. 

      .xlt

    • B. 

      .xox

    • C. 

      .xls

    • D. 

      .html

  • 30. 
    Which of the following is spreadsheet software?
    • A. 

      Microsoft Word

    • B. 

      Microsoft Excel

    • C. 

      Microsoft Access

    • D. 

      Microsoft PowerPoint

  • 31. 
    Which of the following is a correct cell address in Excel?
    • A. 

      A1

    • B. 

      Cell1

    • C. 

      Row1

    • D. 

      1A

  • 32. 
    Bold, italic, underline and alignment are _____ options.
    • A. 

      Excel options only

    • B. 

      Shared options

    • C. 

      Formatting options

    • D. 

      Tool options

  • 33. 
    To keep table headings visible you can use
    • A. 

      Hold panes

    • B. 

      Line panes

    • C. 

      Freeze panes

    • D. 

      Spreadsheet panes

  • 34. 
    Which is the correct formatting of a formula?
    • A. 

      (A2+E3)

    • B. 

      =+(A2+E4

    • C. 

      =(A2+B4)

    • D. 

      =A2+B4

  • 35. 
    The values in cells A1 to A5 are all 10.  If we used the Auto SUM function, what is the value of =SUM(A1:A5)?
    • A. 

      5

    • B. 

      50

    • C. 

      500

    • D. 

      100

  • 36. 
    To save a workbook with a different name you should use
    • A. 

      Save all

    • B. 

      Save

    • C. 

      Save as

    • D. 

      Save once

  • 37. 
    True or False. It is possible to insert an image into a spreadsheet.
    • A. 

      True

    • B. 

      False

  • 38. 
    The alphabets in the spreadsheet are...
    • A. 

      Columns

    • B. 

      Rows