Excel Quiz

13 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

ECDL Excel Quiz


Questions and Answers
  • 1. 
    • A. 

      This is because a blank row or column can effect a formula result.

    • B. 

      It makes the formula look nice.

    • C. 

      Makes it easier to use formulas

  • 2. 
    Identify the error value
    • A. 

      ########

    • B. 

      Wrong answer

    • C. 

      %%%%%%%

  • 3. 
    The SUM Function is usd to find the total fo a specified cell range?
    • A. 

      True

    • B. 

      False

  • 4. 
    The AVERAGE  Function is used to find the average value in a specified cell range?
    • A. 

      True

    • B. 

      False

  • 5. 
    You can count Text using the COUNT function?
    • A. 

      True

    • B. 

      False

  • 6. 
    Which comparison operator will help you find the value in the IF Function?
    • A. 

      "

    • B. 

      =>

    • C. 

      !

  • 7. 
    A cell should only contain one element of data?
    • A. 

      True

    • B. 

      False

  • 8. 
    The default position for text within a cell is left aligned
    • A. 

      True

    • B. 

      False

  • 9. 
    The default position for numbers and dates is right aligned?
    • A. 

      True

    • B. 

      False

  • 10. 
    • A. 

      True

    • B. 

      False

  • 11. 
    The Sort A to Z is for acending order
    • A. 

      True

    • B. 

      False

  • 12. 
    The Sort Z to A is for decending order?
    • A. 

      True

    • B. 

      False

  • 13. 
    Gridlines is in the Page setup in the Layout tab?
    • A. 

      True

    • B. 

      False