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

 

Class – 10^th

Subject – IT (402)

UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED)

Revision Test-1

Fill in the blanks

1) _____________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 ______________ worksheet.

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

4) A ________________ 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 ____________ of the worksheets in the workbook.

6) A ___________ 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 ___________ link will stop working only if the target is moved.

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

9) ____________ 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) _____________ 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.