U-2 Electronic spreadsheet Imp Fill up/ Class -10IT (402),class-10 IT(402) Book -Domestic Data Entry

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 menu, you can discover what values will produce the result that you want

7) Solver option under Tools menu amounts to a more elaborate form of Goal Seek.

SESSION 2: LINK DATA AND SPREADSHEETS

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

2) 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.

3) There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse.

4) Spreadsheet software allows the user to share the workbook and place it in the Network location where several users can access.

5) Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.

SESSION 3: SHARE AND REVIEW A SPREADSHEET

1) Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously.

2) The Comment column by default contains an explanation of the change that was made.

3) Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In this case, it may be quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides the feature of merging worksheets.

4) Spreadsheet software can find the changes by Comparing Sheets.

5) Excel comments are used to add a note or explain a formula in a cell. Excel provides users with the flexibility of editing, deleting, and showing or hiding comments on an Excel worksheet. Users can also resize and move the Excel comment box.

6) Choose Edit > Changes > Comments. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited. Type your own comment and click OK.

7) Spreadsheet software allows the user to share the workbook and place it in the shared location where several users can access.

SESSION 4: CREATE AND USE MACROS IN SPREADSHEET

1) Macros are useful to repeat a task the same way over and over again.

2) A macro is a saved sequence of commands or keystrokes that are stored for later use.

3) Macros are useful to repeat a task the same way over and over again.

4) we record a Macro by steps using tools - - > macros - - > Record Macro

Search This Blog

ASK IN DETAIL