Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 141 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 141

    4.  Do as Directed                                                                             4×2.5=10
                      a. Your spreadsheet contains student grades for multiple subjects. You want to sort the data
                         based on the average grade for each student in ascending order. How would you perform
                         this sorting operation?
                      b. How would you use the IF() function to determine if a student has passed or failed based on
                         their score? Provide a sample Excel formula and explain its components.
                      c. You  need to  create  a table  on a webpage  to  display  a  list  of students  with  their  names,
                         ages,  and grades.  How would you  use  HTML  table  elements  (<table>,  <tr>,  <th>,  <td>)
                         to organise and present this information?

                      d. You need to create a numbered list of steps for a recipe on a cooking blog. How would you
                         use an HTML ordered list (<ol>) to list these steps, and what HTML tags would you use for
                         each step?

                      140   Premium Edition-VII

| 136 137 138 139 140 141 142 143 144 145 |