Take Another Quiz

Excel 2010

10 Questions
Microsoft Excel Quizzes & Trivia

To raise awareness of Excel 2010 and help deal with client spreadsheets.

Questions and Answers
  • 1. 
    Which of the following tasks can be performed with Excel?
    • A. 

      Create a spreadsheet

    • B. 

      Create a chart

    • C. 

      Summarise numerical data

    • D. 

      All of the above

  • 2. 
    True or False: By clicking Control+Home it will take you to the cell in Column A of the current row.
    • A. 

      True

    • B. 

      False

  • 3. 
    • A. 

      Calibri 11 point

    • B. 

      Times New Roman 12 point

    • C. 

      Arial 10 point

    • D. 

      Century Gothic 10 point

  • 4. 
    If you were asked to double-click something, what would you do?
    • A. 

      Press and release the left mouse button quickly twice

    • B. 

      Press and release the right mouse button quickly twice

    • C. 

      Press and release the left and right mouse buttons together

    • D. 

      Press and release the left and right mouse buttons together quickly twice

  • 5. 
    True or False: Headers and footers only apply to a specific worksheet not the entire workbook
    • A. 

      True

    • B. 

      False

  • 6. 
    What appears in a cell when a column is not wide enough for its numerical contents?
    • A. 

      ??????????

    • B. 

      ##########

    • C. 

      >>>>>>>>>>

    • D. 

      !!!!!!!!!!

  • 7. 
    Which of the following can be used for emphasis in all of Rollits' documents?
    • A. 

      Bold

    • B. 

      Underline

    • C. 

      Block capitals

    • D. 

      All of the above

  • 8. 
    True or False: Pressing the control key whilst inserting a semi colon enters the current date
    • A. 

      True

    • B. 

      False

  • 9. 
    When you enter a formula in Excel, what sign must go in front of the formula?
    • A. 

      >

    • B. 

      #

    • C. 

      =

    • D. 

      !

  • 10. 
    True or False: Excel's Find and Replace feature can find words, numbers and formatting.
    • A. 

      True

    • B. 

      False