Page 33 - TP-Play_V-2.0_Book-6
P. 33
C. 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.
.....................................................................................................................................................................................................
D. 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 the examples.
21 st #Critical Thinking
Century
E. Competency-based/Application-based question: Skills #Experiential Learning
Divya has made a spreadsheet for the marks obtained by the students of her class in different subjects.
Which feature should she use to keep the spreadsheet updated if she has to change marks in one of
the subjects of any student?
..........................................................................................................................................................................................................
21 st #Technology literacy
Century
Skills #Productivity & Accountability
In the lab
Create a similar invoice in Excel 2016.
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 Invoice amount payable.
Teacher's Corner
1. Explain different types of functions provided by Excel 2016 to the students.
2. Do a walk-through of all the topics covered in this chapter.
Formulas and Functions 33

