Microsoft Excel Functions Knowledge Test! Trivia Quiz

38 Questions | Total Attempts: 78

SettingsSettingsSettings
Please wait...
Microsoft Excel Functions Knowledge Test! Trivia Quiz

.


Questions and Answers
  • 1. 
    The ___ function adds all of the numbers in a range of cells
  • 2. 
    Number values are often called labels.
    • A. 

      True

    • B. 

      False

  • 3. 
    Cell contents are either values or formulas.
    • A. 

      True

    • B. 

      False

  • 4. 
    The values that an Excel function uses to perform operations are called
  • 5. 
    An excel document is called a
  • 6. 
    A ______is formatted as a pattern of uniformly spaced horizontal rows and vertical columns
  • 7. 
    An excel formula begins with which symbol?
  • 8. 
    The____allows the user to enter or edit he value or formula contained in the active cell.
  • 9. 
    Two or more cells that Excel treats as a single unit is called a
  • 10. 
    The ____is outlined in black and is ready to accept data. 
  • 11. 
    Anything a user types into a cell is known as a
  • 12. 
    The small black square in the lower right corner of a selected cell is called a
  • 13. 
    Values are compared using a ___ operator
  • 14. 
    The _____ function counts the number of cells within a range that meets a certain criteria.
  • 15. 
    Excel’s ____ function retreats the date and time from the computer’s calendar and clock.
  • 16. 
    To ___ a table means to arrange all of the data in a specific order. 
  • 17. 
    A gallery of text styles that can be used to apply decorative effects to text is called a 
  • 18. 
    An image that appears to have length, depth and width is said to be
  • 19. 
    The Excel operator for greater than or equal to is said to be 
  • 20. 
    Each pie slice displayed on a pie chart is an example of a
  • 21. 
    A ___ _______ shows the relationship of each part of the data to the whole.
  • 22. 
    You would ____ a table if you wanted to display only data that matched specific criteria. 
  • 23. 
    By including worksheets in a _____ you can enter or edit data on them simultaneously. 
  • 24. 
    A predefined formula is called a
  • 25. 
    On a line chart, the y-axis is known as