Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 149 - 2610_Springdales_C-7
P. 149

    Practical Assessment

                     Excel                                                                            21 st  Century   #Technology Literacy
                                                                                                          Skills
                                                                                                              #Critical Thinking
                      1.   Create the following spreadsheet in Excel and perform the operations given below:

                                              Name             Age           Gender           Score

                                          Rahul           12              Male           85

                                          Priya           14              Female         92

                                          Aryan           13              Male           78

                                          Nisha           11              Female         95

                                          Vikram          15              Male           80

                                          Ananya          16              Female         88
                                          Rohit           10              Male           75

                                          Sneha           12              Female         90

                         a.   Apply conditional formatting on the column Age to display the students age in red colour who are below
                            13.

                         b.  Sort the records in ascending order of the basis of Score column.

                         c.  Display the records of Female students only.                             21 st  Century   #Technology Literacy
                                                                                                          Skills
                                                                                                              #Creativity
                     HTML

                      1.  Create the following table in HTML. Also apply border style and colour to decorate it.

                                                                                               Price
                            Product                       Description                                        Quantity
                                                                                           Unit    Total
                          Pencils       HB pencils, pack of 12                            2       75       50

                          Pens          Ballpoint pens, assorted colors, pack of 10       2       60       30
                          Notebooks College-ruled notebooks, pack of 3                    4       70       20

                          Markers       Highlighter markers, assorted colors, pack of 6   5       68       15

                                                                                                Practical Assessment   147

| 144 145 146 147 148 149 150 151 152 153 154 |