Page 33 - TP_V5.1_C7_fb
P. 33
Hashtag
#Function: A predefined formula in Excel
#Error: Mistakes performed while using functions
REVISIT
▶ A function is a predefined formula in Excel.
▶ Function name must be a valid Excel name.
▶ Some mathematical functions are SUM, PRODUCT, MOD, etc.
▶ Some text functions are CONCATENATE (text1, text2), LEFT(text, num_chars), LEN(text), etc.
▶ Some logical functions are MAX, MIN, AVERAGE, etc.
▶ Some date and time functions are TODAY(), MONTH(TODAY()), YEAR(TODAY()), etc.
▶ Some common errors are ####, #Div/0!, #VALUE!, etc.
1. Tick ( ) the correct option.
a. Which of the following functions is used to calculate the average of a range of values?
(i) AVERAGE (ii) SUM
(iii) AVG (iv) None of these
b. What is the use of NOW() function?
(i) Current date (ii) Current time
(iii) Current day (iv) Both (i) and (ii)
c. Which of the following functions finds the number of values in the given set of values?
(i) COUNT ( ) (ii) SUM ( )
(iii) MAX ( ) (iv) Both (i) & (ii)
d. Which of the following errors occurs when data is not available?
(i) #### (ii) #VALUE!
(iii) #N/A (iv) #NUM!
2. Fill in the blanks using the words from the help box.
MIN(), LEN, function, #REF!, square root
a. The SQRT function returns the __________ of the given number.
b. The __________ function returns the smallest value.
c. The __________ error means the cell reference is not valid.
Functions in Excel 31

