Page 30 - Computer - 8

Mind Stretching

1. Puneet runs a shop which undertakes photocopying and scanning jobs. He wants to expand his
work to increase his profits. He maintains the data related to his income and expenditure in an
Excel worksheet. He wants to limit his percentage of expenditure on purchasing paper to 20%
from the current 25%. Which option in Excel can help him do so? Logical Thinking

2. Mohini created a data table in Excel for her monthly shopping for household items. She now wants to
apply subtotals to the data to calculate the amount spent each item, but she is not getting the desired
result. What could be the reason for her problem? How can she correct it? Computational Skills

Lab Work Computational Skills

A. Create the worksheet structure as shown in the image.
The values under Tax Paid column are a specified
percentage of the values under the Salary column.
Apply the validation rules as described below on the
specified columns:
(a) The values under the Salary column cannot be more than 100000.
(b) The values under the DeptNo column must be one out of 10, 20, 30, or 40.
(c) The length of text entries under the EmpName column must be 25 characters or less.
(d) Display appropriate messages when data is entered under the columns on which validation rules are
applied.
(e) Add at least 10 records in the worksheet.
(f) Add two scenarios for the Tax Paid column – one with tax calculated as 10% of the salary and the
other with tax calculated as 15% of the salary.
B. Create a worksheet as shown in the image.

Create a Pivot table for the data to show the sum of sales amount. The Book name should be displayed
as row headings and class should be displayed as column headings.

TEACHER’S DESK
TEACHER’S DESK
Explain to the students the use of different tools and features in Excel to work with databases.

28