Page 121 - Code & Click - 8

P P RR OO JJ EE CC TT S S

A. Excel 2016
1. Create the worksheet as shown in the image and enter at least 20 records in it.

Perform the following operations on the worksheet data.
(a) Sort the data on the basis of Product column.
(b) Filter the data on the basis of Material column to display records for bolts.
(c) Apply subtotals to the data displayed at each change in material.
2. Create a datasheet to record the sales amount for a café for different weeks over several
months.
Create a Pivot table for the data that displays the product names as row headings, month
names as column headings, the sum of sales amount as data values, and week number as
filter for the Pivot table.

B. HTML5 and CSS

1. Create a web page on applications of Artificial Intelligence. Use hyperlinks to move from one
page to another. Use various HTML elements to make the pages attractive.

(Sample web pages are given for your reference)

119