2nd Yr MS Excel 2007

39 Questions | Attempts: 393
Share

SettingsSettingsSettings
2nd Yr MS Excel 2007 - Quiz

Some people have had computers with them but are still unable to make maximum use of the excel sheet. As a second year student you should by now know how to use Microsoft office. Test your knowledge on Microsoft excel by taking this simple quiz. All The best in your studies!


Questions and Answers
  • 1. 
    The numbers, text, or cell references used by the function to return a value are
    • A. 

      Expressions

    • B. 

      Arguments

    • C. 

      Data

    • D. 

      Values

  • 2. 
    The ____ button is equivalent to using the sum button.
    • A. 

      COUNT

    • B. 

      ADD

    • C. 

      AutoSum

    • D. 

      AddSum

  • 3. 
    Formatting changes only the appearance of data- it does not affect the data itself.
    • A. 

      True

    • B. 

      False

  • 4. 
    After you merge a range into a single cell, you can't realign its content.
    • A. 

      True

    • B. 

      False

  • 5. 
    You can rotate cell contents in Excel so that they appear at any angle or orientation.
    • A. 

      True

    • B. 

      False

  • 6. 
    When a worksheet is printed, the grid lines that surround the cells are printed by default.
    • A. 

      True

    • B. 

      False

  • 7. 
    A conditional format can make negative numbers red and positive numbers black.
    • A. 

      True

    • B. 

      False

  • 8. 
    Once you hide a row, it remains hidden as long as the workbook is active.
    • A. 

      True

    • B. 

      False

  • 9. 
    What is a workbook made up of?
  • 10. 
    Multiplication before addition is an example of ____________________
  • 11. 
    When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.
  • 12. 
    A named operation that returns a value is a ______.
  • 13. 
    A group of worksheet cells is called a _________.
  • 14. 
    Pressing Ctrl + ' switches to the _________ view.
  • 15. 
    A _______________ is an excel document.
  • 16. 
    The _____________ button quickly inserts Excel functions.
  • 17. 
    The _________________ displays the name of the sheets in the workbook.
  • 18. 
    The ____________ displays the cell reference of the active cell.
  • 19. 
    If there are too many numbers after the decimal place displayed in a cell, creating a distraction from the data, you could make the data appear cleaner by:
    • A. 

      Reenter all the numbers

    • B. 

      Decrease the column width

    • C. 

      Decrease the font size

    • D. 

      Use the Number group to decrease the number of digits displayed

  • 20. 
    If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:
    • A. 

      Type the data in A1 and Merge cells A1:A5

    • B. 

      Type the data in A1 and Merge cells A1:E1

    • C. 

      Type the data in C1

    • D. 

      Choose Center from the Format menu

  • 21. 
    The most efficient way to format several cells with a specific font, number format, alignment, fon color would be to:
    • A. 

      Use Format Painter

    • B. 

      Format each element using the Toolbar

    • C. 

      Select all and use the Formatting dialog box

    • D. 

      Apply a table style

  • 22. 
    When creating an Excel document, you should avoid using ______ text and background together, since this is the most common form of color blindness.
    • A. 

      Red and green

    • B. 

      Yellow and blue

    • C. 

      Black and white

    • D. 

      Red and yellow

  • 23. 
    As a general rule you should______________
    • A. 

      Center column titles, left align text, and right align numbers

    • B. 

      Center column titles, right align text, and left align numbers

    • C. 

      Right column titles, left align text, and right align numbers

    • D. 

      Left column titles, left align text, and right align numbers

  • 24. 
    The Paste Options button allows you to________.
    • A. 

      Keep source formatting

    • B. 

      Copy formatting only

    • C. 

      Copy values only

    • D. 

      All of the above

  • 25. 
    Put the following five steps in the order in which you would perform them to use the Paste Special function: 1. Select and copy a range 2. Click the Paste button arrow in the Clipboard group 3. Specify exactly what you want to paste 4. Click Paste Special to open the dialog box 5. Select the range where you want to pase the Clipboard contents
    • A. 

      1, 2, 4, 3, 5

    • B. 

      1, 2, 4, 5, 3

    • C. 

      1, 5, 2, 4, 3

    • D. 

      1, 5, 2, 3, 4

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.