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

