Take Another Quiz

Cgs1060

38 Questions
Online Test Quizzes & Trivia
Questions and Answers
  • 1. 
  • 2. 
    Number values are often called labels
    • A. 

      True

    • B. 

      False

  • 3. 
    • 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. 
  • 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 
  • 26. 
    The spacing between the tick marks is determined by the 
  • 27. 
    If you want to chart trends over time use a
  • 28. 
    On a line chart, the x-axis is known as the 
  • 29. 
    Goal Seek is an example of a
  • 30. 
    Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing
  • 31. 
    An Excel worksheet is made up of one or more workbooks.
    • A. 

      True

    • B. 

      False

  • 32. 
    You can select an element of a chart to format by using the chart’s element box. 
    • A. 

      True

    • B. 

      False

  • 33. 
    Excel does not have a spell checker
    • A. 

      True

    • B. 

      False

  • 34. 
    Arithmetic operators are used to perform basic mathematical operations in Excel. 
    • A. 

      True

    • B. 

      False

  • 35. 
    If a value is changed in in a cell, Excel recalculates all formulas that reference that cell.
    • A. 

      True

    • B. 

      False

  • 36. 
    When the user changes a value in a cell, Excel automatically recalculates. 
    • A. 

      True

    • B. 

      False

  • 37. 
    A pie chart should be limited to no more than seven categories
    • A. 

      True

    • B. 

      False

  • 38. 
    .A menu that is context sensitive displays options related to the current task. 
    • A. 

      True

    • B. 

      False

Related Topics