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

7 Questions | Total Attempts: 76

SettingsSettingsSettings
HR Lunch N

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

  • 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

  • 3. 
    Which team has the highest average weight?
    • A. 

      Denver Broncos

    • B. 

      Chicago Bears

    • C. 

      Green Bay Packers

    • D. 

      Chicago Bulls

  • 4. 
    Which team has the most wide receivers on their roster? 
    • A. 

      Green Bay Packers

    • B. 

      Chicago Bears

    • C. 

      Denver Broncos

    • D. 

      Milwaukee Brewers

  • 5. 
    Which team has the highest turnover rate?
    • A. 

      Green Bay Packers

    • B. 

      Chicago Bears

    • C. 

      Denver Broncos

    • D. 

      Colorado Rockies

  • 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.

Back to Top Back to top