Page 33 - TP_Pro_V5.1_Class6
P. 33
4. Think and answer.
a. What is a cell reference in Excel?
______________________________________________________________________________________
______________________________________________________________________________________
b. How do you enter a formula directly into a cell?
______________________________________________________________________________________
c. Write the purpose of the SUM function in Excel.
______________________________________________________________________________________
d. Summarise the use of the CONCATENATE function.
______________________________________________________________________________________
______________________________________________________________________________________
e. How do you select a range of cells using the mouse in Excel?
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
5. Differentiate between the following:
a. Relative Cell Referencing Absolute Cell Referencing
______________________________________ ______________________________________
______________________________________ ______________________________________
b. Comparison Operators Reference Operators
______________________________________ ______________________________________
______________________________________ ______________________________________
21 st
6. Competency-based/Application-based questions. Century #Technology Literacy
Skills
a. Adhyay entered a ten-digit number in Excel. He now wants to extract the last three digits of this
number. Which function should he use for this? Also write the syntax.
b. Gaurav wants to compare the values of two different columns. He wants to check
whether the values are equal or not. Which operator should he use? Give the symbol for
that operator.
21 st #Communication
GROUP DISCUSSION Century #Social Interaction
Skills
Divide the students into two groups and discuss the difference between Mathematical Function
and Logical Function.
Formulas and Functions in Excel 2021 31

