Excel Function | MCQs

Explanation

The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition.

The condition is referred to as criteria , which can check things like: If a number is greater than another number >

***

RY24012023

Explanation

• Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)
***

• The Average function calculates the average, or arithmetic mean, of its arguments.
• The Max function finds the maximum value.
• The Min function finds the minimum value.
• The Sum function calculates the sum of its arguments.