End of workshop

Which functionin Excel checks whether a condition is true or not ?

• SUM

• COUNT

• IF

• AVERAGE

Which of the following returns one value if the condition is TRUE, or another value if the condition is FALSE

• IF function

• IFS function

• COUNT function

• COUNTA function

Which of the following Sums the values in a range that meets the criteria that you specify

• SUM function

• SUMIF function

• SUMIFS function

• SUMMATION

This function adds the value of items which match criteria set by the user.

• COUNTIF

• SUMIF

• SUM

• COUNT

This function tests a condition.

If the condition is met it is considered to be TRUE.

If the condition is not met it is considered as FALSE.

Depending upon the result, one of two actions will be carried out.

• COUNTIF

• SUMIF

• IF

• DATEDIF

Which of the following function will use to find the highest number in a series of number ?

• =HIGH(B1:B3)

• =MAXIMUM(B1:B3)

• =MAX(B1:B3)

• None of the above

Which of the following is correct syntax in Excel ?

• =IF(Logical Test ,True Result) ,IF(Logical Test, False Result)

• =IF(Logical Test, True Result) (Logical Test, False Result)

• =IF(Logical Test ,(True Result , False Result))

• =IF(Logical Test, True Result , False Result)

What is the purpose of the SUMIFS function in Microsoft Excel?

• To find the average of values in a range

• To sum values in a range based on multiple criteria

• To calculate the maximum value in a range

• To count the number of cells in a range that meet multiple criteria

How is the AVERAGEIFS function used in Microsoft Excel?

• It is used to calculate the sum of a range of cells that meet multiple criteria.

• It is used to find the maximum value in a range of cells based on multiple criteria.

• It is used to calculate the average of a range of cells that meet multiple criteria.

• It is used to format the text in a range of cells based on multiple criteria.

What are the advantages of using SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, and MINIFS functions over traditional formulas in Excel?

• They allow for multiple criteria to be applied to the calculation, providing more flexibility and accuracy in data analysis.

• They are not compatible with the latest versions of Excel

• They only work with numerical data, limiting their usefulness

• They are more time-consuming to use than traditional formulas