Excel Knowledge Test! Ultimate Trivia Quiz

13 Questions | Total Attempts: 1770

SettingsSettingsSettings
Please wait...
Excel Knowledge Test! Ultimate Trivia Quiz


Questions and Answers
  • 1. 
    Why is it good practice to avoid creating blank rows and columns in the main body in a list?
    • A. 

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

    • B. 

      It makes the formula look nice.

    • C. 

      It makes it easier to use formulas.

  • 2. 
    Identify the error value
    • A. 

      ########

    • B. 

      Wrong answer

    • C. 

      %%%%%%%

  • 3. 
    The SUM function is used 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. 
    To select an adjacent cell range to hold down the CTRL key and click the cell or drag over the cells to be selected?
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False