Page 33 - Trackpad_V1_Book 6_Flipbook
P. 33
c. __________ is used in a formula to denote a specific cell.
d. A __________ is a predefined formula in Excel.
e. The __________ function is used to get the length of the string.
3. Think and answer.
a. What are formulas in Excel?
___________________________________________________________________________________
b. What is operator precedence?
___________________________________________________________________________________
c. What is the use of the CONCATENATE() function? Explain with an example.
___________________________________________________________________________________
___________________________________________________________________________________
d. What is cell range? How can you select a cell range by using the mouse?
___________________________________________________________________________________
___________________________________________________________________________________
e. Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel. Also, write a tip to resolve them.
___________________________________________________________________________________
___________________________________________________________________________________
___________________________________________________________________________________
4. Define the following functions:
a. MAX() _________________________________________________________________________
b. TODAY() _________________________________________________________________________
c. LEN() _________________________________________________________________________
5. Differentiate between the following:
a. Relative Cell Referencing Absolute Cell Referencing
_____________________________ _____________________________
_____________________________ _____________________________
b. Comparison Operators Reference Operators
_____________________________ _____________________________
_____________________________ _____________________________
6. Application based question: Experiential Learning
Alisha was using Excel and encountered an error that displayed ‘#Div/0!’. She doesn’t know
about this error. Tell her the meaning of this error and also give a tip to resolve this.
___________________________________________________________________________________
Formulas and Functions in Excel 2010 31

