The City School
Kharian Campus
Class: 5T Name: ___________
Q1) Match the columns 05
CONCATENATE This function is used to calculate the number of cells that contain
numbers.
TODAY These formulas are used to extract a part of a string (sub-string).
COUNT To have the current date displayed on your worksheet.
SUBSTITUTE This function is used to join text values from multiple cells into one cell.
LEFT, RIGHT, MID This function is used to replace a part of the text in a cell.
Q2) Define “COUNT IF”. 02
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
Q3) if we apply SUBSTITUTE function in Cell A2, = SUBSTITUTE (A1, “Canada”, “Pakistan”) 01
What would be the output in cell A2?
A
1 We live in Canada
2
Q4) Define IF function. 02
Fill in the blanks: [05]
a) Excel is a ____________________ program that allows you to store, organize and analyze
information.
b) The ______________ feature will allow you to set a column’s width to fit its content
automatically.
c) _____________ allows you to combine a cell with adjacent empty cells to create one large
cell.
d) The Excel ______________ function returns the smallest value from a supplied range of cell.
e) The Excel ______________ function allows you to combine text from different cells into one
cell.
1. Put a if the sentence is correct
1. The “IF” logical function returns a value if the condition is true.
2. The “IF” function can return another function as a result.
3. The returned value from a logical function cannot be text.
4. The only way to use a Logical function is to insert it from the Function Library.
5. The value that is returned if a Logical_test is true is always text.
6. The value that is returned if a Logical_test is false can be the addition of two
numbers.
7. The criteria you type in a Logical_test must always contain comparison
operators.
Write down the short answer the following questions: [08]
a. Write down the function of MAX function.
__________________________________________________________________________________
____________________________________________________________________________
b. What is the purpose of IF Function?
_______________________________________________________________________________
_______________________________________________________________________________
c. Describe fill handle feature.
__________________________________________________________________________________
____________________________________________________________________________
a. Write down the syntax of IF Function.
__________________________________________________________________________________
____________________________________________________________________________
