U-2 Spreadsheet / Class-10th IT402/ Test-1 Ans

 

Class – 10^th

Subject – IT (402)

UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED)

Revision Test-1

Answer

Fill in the blanks

1) Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.

2) Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet.

3) SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows.

4) A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.

5) At the bottom of each worksheet window is a small tab that indicates the name   of the worksheets in the workbook.

6) A  cell reference  refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.

7) An absolute link will stop working only if the target is moved.

8) A relative link will stop working only if the start and target locations change relative to each other.

9) Goal seeking is the process of finding the correct input value when only the output is known. The function of goal seeking can be built into different kinds of computer software programs like Microsoft Excel.

10) Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.