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.
SUMIF
AVERAGEIFS
DCOUNT
COUNTIFS
Rate this question:
2
3
2.5
None of the above
Rate this question:
=IF(AND)(B10>B5), B11>=2), 200, 45)
=IF(AND)(B10-B5>=5, B11
=IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50),45)
=IF(OR(B10>B5, B11>=2), MAX(200,50),45)
Rate this question:
Range
Criteria c. Sum_range d. average_range. Criteria
Sum_range
Average_range.
Rate this question:
Rows
Columns
Cells
Rate this question:
0-1
1-2
2-3
3-4
Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.