# Work Assessment Trivia Questions

6 Questions  Settings  Mathematicians and physicists and all other careers out there all undergo work assessment. Get ready for your knowledge to be tested on various work assessment trivia questions to advance your knowledge on the subject. All the best.

Related Topics
• 1.
A workbook contains a list of university students. You want to identify the total number of students who are seniors and who are majoring in biology. Without modifying the original student dataset, what function can you use to find the answer to your question?
• A.

SUMIF

• B.

AVERAGEIFS

• C.

DCOUNT

• D.

COUNTIFS

• 2.
2. A worksheet contains test scores for students in an aviation class. The scores are 95, 90, 90, 85, 75, 75, 70, and 60. Using the new RANK function in MS Excel that is considered a 'best practice', what is the rank of the second student who scored 90?
• A.

2

• B.

3

• C.

2.5

• D.

None of the above

• 3.
A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record, the officer will fine the speeder the higher of \$200 or \$50 for each mile over the speed limit. Otherwise, the fine is \$45. The speed limit is entered in cell B5, the person's speed is entered in cell B10, and the person's number of previous tickets is entered in cell B11. What function derives the correct answer?
• A.

=IF(AND)(B10>B5), B11>=2), 200, 45)

• B.

=IF(AND)(B10-B5>=5, B11

• C.

=IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50),45)

• D.

=IF(OR(B10>B5, B11>=2), MAX(200,50),45)

• 4.
The SUMIF function calculates the total of a ___ of values when a specified condition is met.
• A.

Range

• B.

Criteria c. Sum_range d. average_range. Criteria

• C.

Sum_range

• D.

Average_range.

• 5.
The CUNTIF function counts the number of___ in a range when a specified conditions is met.
• A.

Rows

• B.

Columns

• C.

Cells

• 6.
The PERCENTRANK function identifies a value’s rank as a percentile between_____ of a list of value.
• A.

0-1

• B.

1-2

• C.

2-3

• D.

3-4