Page 35 - TP_V5.1_C7_fb
P. 35
6. Competency-based/Application-based questions. Experiential Learning
a. 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.
_____________________________________________________________________________________
b. Shivam is adding date and time in his Excel sheet. Which function will he use to add for getting the
current system date and time?
_____________________________________________________________________________________
GROUP DISCUSSION Communication
Divide the students into two groups and discuss the difference between Mathematical Function
and Logical Function.
LAB ACTIVITY Subject Enrichment
Visit your computer lab and perform the following actions:
▶ Open a worksheet, enter your first name in the A3 cell and the last name in the B3 cell. Now
concatenate your first and last name using the text formula in cell E5.
▶ Create a similar invoice in Excel.
(a) Fill-up details of five items, their quantities and unit prices.
(b) Using Product function, calculate the amount for each item.
(c) Using SUM function, calculate the total amount.
(d) Using formula, calculate the GST according to the given rate.
(e) Calculate Invoice amount payable.
▶ Create a similar worksheet:
Set the status of stock as "Order" if the Quantity in Stock is less than 20, otherwise "No Action" by
using the IF() function.
Functions in Excel 33

