U-2 Electronic spreadsheet Imp Fill up/ Class -10IT (402),class-10 IT(402) Book -Domestic Data Entry
U-2 Electronic spreadsheet Imp Fill up/ Class -10IT (402),class-10 IT(402) Book -Domestic Data Entry Students study this Unit 2:Electronic Spreadsheet (Advanced) : Important Fill in the blanks SESSION 1: ANALYSE DATA USING SCENARIOS AND GOAL SEEK 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 that you can update easily. 3) SUBTOTAL , totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows. 4) Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. 5) 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. 6) Goal Seek option under Tools me