Question

(b)An NGO is collecting donations from various parts of your city for flood victims. The itemscollected are toys, blankets, bed-sheets, clothes, footwear, food items (biscuits, wafers, choco-lates, bread) etc. Prepare a comprehensive spreadsheet on the item collected from all areas.Thereafter prepare an appropriate chart analyzing the collection made.​

Answer 1

Explanation:

In order to design the spreadsheet it would look like this;

Rows

In rows, we will list down all the areas, like Town A , Town B, Town C etc

Columns

while in columns we list all the food items such as  toys, blankets, bed-sheets, clothes, footwear, food items (biscuits, wafers, chocolates, bread). Then the last column would sum all the items area wise and the last row of table shall sum all the items type wise

Answer 2

Explanation:

In order to design the spread sheet would look like this;

Rows

In Rows we will note down all areas like Town A, Town B, Town C

Columns

While in column we will note down all the food items such as toys, blankets, bedsheets, clothes, foot wear, food items. Then the last column would sum all the items area wise and the last row of table shall sum all the items type wise.