Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    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

| 59 60 61 62 63 64 65 66 67 68 69 |