Page 91 - PlusGPT_V2.1_C7_Flipbook
P. 91
d. What are the rules to enter a function?
_______________________________________________________________________________________
_______________________________________________________________________________________
e. What is the difference between formula and function? Give two examples.
_______________________________________________________________________________________
_______________________________________________________________________________________
fun Zone
Let's soLve
Application based question. Critical Thinking
Aman is organising an event and needs to set exact dates and times for activities. Which functions
should he use to find the current date and the current month?
Let's exPLore Communication
Talk to the various departments in your school and find out how to use Excel. Discuss with
your class.
teCh PraCtiCe Life Skills & Values
Create a similar invoice in Excel 2016.
1. Fill-up details of five items, their quantities
and unit prices.
2. Using PRODUCT function, calculate the
amount for each item.
3. Using SUM function, calculate the total amount.
4. Using formula, calculate the GST according to the given rate.
5. Calculate Invoice amount payable.
For The Teacher
Explain different types of functions provided by Excel 2016 to the students.
Do a walk-through of all the topics covered in this chapter.
Formulas and Functions 89

