Page 87 - 2622_Delhi Police Public School_C-6

B 150 20
C 80 30

D 200 40

Now, he wants to calculate the total amount for each product. Which function of Excel will help him
to do so?
b. Mayra has written her first and last names in cells F1 and F2, respectively. To display the complete
name, she has entered the following formula in cell F3:
=CONCATENATE(F1+F2)
However, she does not get the correct output. What could be the possible reason for not getting
the correct output?

c. Simi is working on a worksheet in which she wants to display the names of the students in
uppercase. Which Excel function will help her to achieve this?

d. Romi wants to calculate the total number of values in a particular range. Which function of Excel
should he use to accomplish this?

A Better Me! 21 st Century #Initiative
#Leadership & Responsibility
Skills
Your neighbour has been preparing a list of grocery items with their prices. She has been manually
calculating the total amount. Do you think you should help people whenever you see an opportunity?

Explore in the Lab 21 st Century #Technology Literacy
Skills
#Productivity & Accountability
To
Subject Preparing Result
Create a worksheet with the following two columns:

A B
Name Score
John 85
Sarah 62

Emily 78
Michael 92
After creating the worksheet, perform the operations given below:
In the Column C, enter the header as Result.

Display the result of each student as Pass if the Score is greater than or equal to 70; otherwise, Fail.
In the Column D, enter the header as Remarks.

Display the remarks as “Good Job!” if the result of the students is Pass; otherwise, “Keep Trying”

For The Teacher
Do a detailed walk-through of all the Excel topics listed in the chapter.
Explain to the children the use of Excel in homes, shops, businesses, industries, etc.

Charts, Formulas & Functions in Excel 85