Page 142 - TP_V5.1_C7_fb
P. 142

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
   137   138   139   140   141   142   143   144   145   146