Chapter. 04. Functions in Excel - V

Chapter 4: Functions in Excel

Fill-in-the-Blank Questions

1. The SUM function is used to calculate the ________ of a range of numbers.

Answer: Total

2. The AVERAGE function returns the ________ of selected numbers.

Answer: Mean

3. The MAX function returns the ________ value in a range.

Answer: Largest

4. The MIN function returns the ________ value in a range.

Answer: Smallest

5. The ________ function is used to find the square root of a number.

Answer: SQRT

6. The IF function is used for ________ comparisons.

Answer: Logical

7. Text can be converted to uppercase using the ________ function.

Answer: UPPER

8. The ________ function joins two or more text strings into one.

Answer: CONCAT

True/False Questions

1. The COUNTIF function can be used to count cells based on a condition.

Answer: True

2. The AVERAGE function is used to find the largest value in a range.

Answer: False

3. NOW() displays the current date and time.

Answer: True

4. The LEFT() function extracts characters from the beginning of a text string.

Answer: True

5. The IF function allows conditional formatting.

Answer: False

6. The LEN() function counts the number of characters in a string.

Answer: True

7. The TRIM() function removes all spaces from text.

Answer: False (only extra spaces, not all spaces)

8. ROUND is used to return an absolute value.

Answer: False

9. You can use the TEXT() function to format numbers.

Answer: True

Answer the Following

1) What is the purpose of the SUM function?

Answer: It calculates the total of a range of numbers.

2) Which function finds the largest value in a dataset?

Answer: The MAX function.

3) What does the LEN function do?

Answer: It counts the number of characters in a string.

4) Which function combines text from multiple cells?

Answer: The CONCAT function.

5) How is the IF function used?

Answer: It performs logical comparisons and returns different values based on conditions.