Page 29 - Computer - 8

INFO RETENTION
INFO RETENTION

A. Select the correct option for each of the following statements.
1. An organised collection of structured information in a computer system is a ______.

(a) table (b) database (c) worksheet (d) document
2. The option to create a table in Excel is available on the ______ tab.
(a) Home (b) Data (c) Insert (d) Review

3. The Subtotal command is available in the ______ group on the Data tab.

(a) Forecast (b) Outline (c) Data Tools (d) Connection
4. The feature in Excel 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

5. The column in a Pivot Table on basis of which the data can be rotated is called ______.

(a) pivot (b) centre (c) axis (d) point

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 Recommended PivotTables command is present in Tables group on the _________ tab.

4. The _________ in Excel lets you create and manage scenarios in a worksheet.
5. When a table is created in Excel, the _________ tab appears on the Ribbon.

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. The rows in an Excel table are displayed in banded colours for greater visibility. _______

4. Tables in Excel support subtotals. _______
5. 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.
4. What is a Pivot table?

5. How is a Pivot table different from a normal data table in Excel?

27