Excel: Telling Your Story With Numbers


SettingsSettingsSettings
Excel: Telling Your Story With Numbers - Quiz

Questions and Answers
  • 1. 

    One way to restructure your data by type or alphabetically, etc. is to use the Sort and/or Filter option in Excel.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
  • 2. 

    The “Paste Value” action allows you to copy/paste the value of a formula function into a new cell. 

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
  • 3. 

    Excel is considered somewhat less effective than other statistical software packages (such as SPSS) for evaluation. 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
  • 4. 

    If you have multiple pieces of data within one cell (i.e., first & last name, or City, State & ZIP), you can separate those into their own cells using the “Text to Columns” action.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
  • 5. 

    In Excel, you can use statistical calculation of “Effect Size” to help answer the question, “Is what we’re doing making a difference?”

    • A.

      True

    • B.

      False

    Correct Answer
    A. True

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • May 01, 2017
    Quiz Created by
Back to Top Back to top
Advertisement