Cgs1060

38 Questions  I  By Cristalespi
Please take the quiz to rate it.

Online Test Quizzes & Trivia

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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 

  • 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


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.