Schmidt
Rynes
Employment Laws
Excel Formulas
Miscellaneous
100

Schmidt states that this is strongly related to job performance.

What is General Cognitive Ability?

100

They are directly responsible for acquiring and disseminating knowledge about best practices

Who are HR professionals?

100

It's not covered by Title VII of the Civil Rights Act of 1964.

What is age?

100

This shortcut ensures that the range in a formula remains static when applying the formula across other cells.

What is fn+F4?

100

The selection rate for a certain group is less than 80% of the entire group.

What is the 4/5ths rule, or Adverse Impact?

200

Schmidt states these are other abilities that are relevant to performance and learning.

What are Psychomotor ability, Social ability, and Physical ability?

200

Research has shown that this is the best way to assess GMA.

What is paper and pencil testing?

200

They bring cases on behalf of those who believe Title VII of the Civil Rights Act of 1964 has been violated.

Who is the EEOC?

200

Allows you to move quickly from the top to the bottom of the screen and back.

What is CTRL+Up or CTRL+Down?

200

Athena and Ambush

Who are Leslee's cats?

300

Job performance ratings for this job are probably less accurate due to supervisors having less opportunity to observe employees.

What is law enforcement?

300

These work well in conjunction with GMA.

What are integrity tests?

300

A manufacturer of men's clothing lawfully advertises for male models.

What is a Bona Fide Occupational Qualification?

300

In Excel, clicking this will provide you additional direction when entering a formula.

What is the fx button?

300

It is one of the most common reasons for EEOC cases.

What is Wrongful Termination.

400

Understanding instructions on forms and reading bus schedules.

What are important health-related behaviors correlated with GCA?

400

These are unlikely to produce adverse impact.

What are integrity tests?

400

This law protects your employees' right to talk about their working conditions.

What is the "National Labor Relations Act"?

400

You must do this to your data range before utilizing the vlookup function, in order to get the correct information?

What is sort your data columns?

400

You don't know what you don't know.

What is an Unconscious Incompetent?

500

They acquire more job knowledge and acquire it faster.

Who are people higher in GCA?

500

Failure to do this leaves money on the table.

What is assess and use GMA?

500

Organizations with 15 or more employees are subject to this law.

What is the Americans with Disabilities Act?

500

In an Excel formula, for every opening one of these, you need a closing one.

What are parentheses?

500

This phrase sums up how an HR specialist should consider all of the information and data regarding recruitment and applicants.

What is "All things considered"?

M
e
n
u