Page 170 - Computer - 8

P P RR OO JJ EE CC TT S S

A. Excel 2019
1. Create the worksheet as shown in the image and enter at least 20 records in it.
(Sample data has been displayed in the image)

Perform the following operations on the worksheet data.
(a) Convert the data into an Excel table.

(b) Sort the data on the basis of Product column.
(c) Filter the data on the basis of Material column to display records for bolts.
(d) 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.
(A sample worksheet is given for your reference).

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.

168