Page 36 - TP_Play_V2.1_class6
P. 36
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 two examples.
.....................................................................................................................................................................................................
.....................................................................................................................................................................................................
.....................................................................................................................................................................................................
21 st #Critical Thinking
Century
E. Competency-based/Application-based question. Skills #Productivity & Accountability
Aman is organising an event and needs to set exact dates and times for activities. Which
functions should he use to find the day, month, year, hour, minute, and second?
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.
34 Play (Ver. 2.1)-VI

