Excel 2007 Intermediate Course Short Quiz

13 Questions | Total Attempts: 51

SettingsSettingsSettings
Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    Your Name
  • 2. 
    A formula cannot contain any of the following: functions, references, operators, and constants.
    • A. 

      True

    • B. 

      False

  • 3. 
    Excel calculates the formula from right to left, according to a specific order for each operator in the formula.
    • A. 

      True

    • B. 

      False

  • 4. 
    Splitting cells content based on a column break is applicable if your data to be separated have a fixed column break location
    • A. 

      True

    • B. 

      False

  • 5. 
    When you remove duplicate values, only the values in the range of cells or table are affected. Any other values outside the range of cells or table are not altered or moved
    • A. 

      True

    • B. 

      False

  • 6. 
    You can use conditional formatting if you want to check if there are duplicate values in the range of cells
    • A. 

      False

    • B. 

      True

  • 7. 
    If you want to restrict data entry to a certain range of cells you will use paste special feature in Excel
    • A. 

      True

    • B. 

      False

  • 8. 
    To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first
    • A. 

      True

    • B. 

      False

  • 9. 
    For cell H9, the relative reference is H9, the absolute reference is $H$9 and the mixed reference is either $H9 or H$9.
    • A. 

      True

    • B. 

      False

  • 10. 
    You can change column width, but you cannot change row height.
    • A. 

      True

    • B. 

      False

  • 11. 
    You can use numbers or cell references in formulas.
    • A. 

      True

    • B. 

      False

  • 12. 
    Which of the following is not an example of an Excel function?
    • A. 

      =SUM(A4:A10)

    • B. 

      =AVERAGE(A4:A10)

    • C. 

      =MIN(A4:A10)

    • D. 

      =A4:A10

    • E. 

      Not Sure

  • 13. 
    When working with validation, you can only filter one column at a time.
    • A. 

      True

    • B. 

      False

Back to Top Back to top