Page 21 - Code & Click - 8

Info Retention
A. Select the correct option for each of the following statements.

1. The Subtotal command is available in the ______ group on the Data tab.
(a) Forecast (b) Outline (c) Data Tools (d) Connection

2. The feature that changes an input cell to get the desired result in a formula cell is ______.
(a) Scenario (b) Goal Seek (c) Pivot Table (d) Subtotals
3. A set of values that Excel saves and can substitute automatically on your worksheet is called
a ______.
(a) Scenario (b) Goal Seek (c) Pivot Table (d) Subtotals

B. Fill in the blanks with the correct answer.

1. The data must be _________ before subtotals can be applied on it.
2. _________ in Excel restricts the type of values that can be entered in a cell.

3. The _________ in Excel lets you create and manage scenarios in a worksheet.
C. Write ‘T’ for True and ‘F’ for False statement.

1. You can create only one scenario for data in a worksheet. _______
2. A List is used to describe a type of data validation on data. _______
3. Goal Seek updates the value of the target cell based on the value in the source
cell of a formula. _______
D. Answer the following questions.

1. What is Goal Seek? How does it work?
2. What is a Scenario in Excel? What is the function of Scenario Manager?

3. Explain the steps in applying subtotals to a list of data in Excel.
Logical Thinking
Mind Stretching

Puneet runs a shop which undertakes photocopying and scanning jobs. 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?

Computational Skills
Lab Work

Create the worksheet structure as shown in the image. Do
as directed:
(a) The values under Salary column cannot be more than
100000.
(b) The values under DeptNo column must be one out of 10, 20, or 30.
(c) Add at least 10 records in the worksheet.
(d) 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.

19