Page 64 - 2611_SmartGPT Pro V(5.0) C-5

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?

21 st
LAB ACTIVITY Century #Technology Literacy
Skills #Productivity & Accountability
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:
(a) In the Column C, enter the header as Result.
(b) Display the result of each student as Pass if the Score is greater than or equal to 70; otherwise,
Fail.
(c) In the Column D, enter the header as Remarks.

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

FOR THE TEACHER

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

62 Computer Science (V5.0)-V