HR Lunch N' Learn - Data - Pre-knowledge Check

7 Questions | Attempts: 76
Share

SettingsSettingsSettings
HR Lunch N Learn - Data - Pre-knowledge Check - Quiz

Hello HR!
As we shared before, we want to keep you engaged on our two focus areas of business acumen and leading change. To do that we would like to test your skills at a SHORT 7 question quiz on data analytics. Please open the excel document that came with this pre-work and use that to complete this quiz.
We will review methods and tips for Excel pivot tables and discuss more about data analytics during our April Lunch N' Learn.
Cheers,
Dorothy & Ryan


Questions and Answers
  • 1. 

    What is the average age of a player who was involuntarily released/waived?

    • A.

      13

    • B.

      26

    • C.

      27.2

    • D.

      28.5

    Correct Answer
    C. 27.2
  • 2. 

    Which team has the collective most years of experience in the NFL?

    • A.

      Denver Broncos

    • B.

      Green Bay Packers

    • C.

      Chicago Bears

    • D.

      Detroit Lions

    Correct Answer
    C. Chicago Bears
  • 3. 

    Which team has the highest average weight?

    • A.

      Denver Broncos

    • B.

      Chicago Bears

    • C.

      Green Bay Packers

    • D.

      Chicago Bulls

    Correct Answer
    C. Green Bay Packers
  • 4. 

    Which team has the most wide receivers on their roster? 

    • A.

      Green Bay Packers

    • B.

      Chicago Bears

    • C.

      Denver Broncos

    • D.

      Milwaukee Brewers

    Correct Answer
    B. Chicago Bears
  • 5. 

    Which team has the highest turnover rate?

    • A.

      Green Bay Packers

    • B.

      Chicago Bears

    • C.

      Denver Broncos

    • D.

      Colorado Rockies

    Correct Answer
    C. Denver Broncos
  • 6. 

    How comfortable are you with your abilities to manipulate data using excel?

    • A.

      Excel-aphobic: I think I'm allergic to that program.

    • B.

      Excel-avoider: Do I have to?

    • C.

      Excel-student: I'm learning!

    • D.

      Excel-user: I can find my way around pretty well.

    • E.

      Excel-guru: Watch my excel voodoo magic in action!

  • 7. 

    How comfortable are you with your abilities to manipulate data using PIVOT TABLES in excel?

    • A.

      Pivot table? I don't think the table needs to be moved...

    • B.

      I'd rather not use a pivot table.

    • C.

      I can use a pivot table - just give me a few minutes to remember how.

    • D.

      I can pivot table in my sleep.

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 19, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 06, 2016
    Quiz Created by
    Dorothy_enriquez
Back to Top Back to top
Advertisement