Page 48 - ModularV1.1 _c7_flipbook
P. 48
C. Write ‘T’ for true and ‘F’ for false.
1. Every formula begins with a + sign. .....................
2. Combined reference is a type of cell reference. .....................
3. The LEN( ) function returns the length of the text. .....................
4. The TODAY( ) function returns the current date. .....................
D. Short answer type questions.
1. What is cell reference?
......................................................................................................................................................................................
2. What is the use of the CONCATENATE( ) function?
......................................................................................................................................................................................
3. What are date and time functions? Write the names of any two date and time functions.
......................................................................................................................................................................................
E. Long answer type questions.
1. What is the use of the LEN function? Explain with example.
2. What are the rules to enter a function?
3. What is the difference between formula and function? Give examples.
In the lab Inter-Disciplinary
Create a similar invoice in MS Excel.
• Fill-up details of five items, their quantities and unit prices.
• Using PRODUCT function, calculate the amount for each item.
• Using SUM function, calculate the total amount.
• Using formula, calculate the GST according to the given rate.
• Calculate the Invoice amount payable.
Teacher's Corner
1. Explain different types of functions provided by MS Excel to the students.
2. Do a walk-through of all the topics covered in this chapter.
46 Modular (Ver. 1.1)-VII

