Class X Information Technology Code
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) (Important Questions) Q 1. What is Consolidating data.
Ans: Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
Q 2. Define Subtotals.
Ans: SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard (Insert > Function). Because of its usefulness, the function has a graphical interface
Q 3. What is Scenarios?
Ans : 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. For example, if you wanted to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results.
Steps to create Scenarios:
Use Scenarios option under Tools menu to enter variable contents —scenarios—in the same cell. To create a scenario:
1) Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the Ctrl key as you click each cell.
2) Choose Tools > Scenarios.
3) On the Create Scenario dialog enter a name for the new scenario
4) Click OK to close the dialog. The new scenario is automatically activated. You can create several scenarios for any given range of cells.
Q 4. What is Goal Seek?
Ans : Usually, you run a formula to calculate a result based upon existing values. By contrast, using Goal Seek option under Tools menu, you can discover what values will produce the result that you want.
Q 5. What is Solver ?
Ans: Solver option under Tools menu amounts to a more elaborate
form of Goal Seek. The difference is that the Solver deals with
equations with multiple unknown variables.
Q 6. Define Cell Reference.
Ans: 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.
In one or several formulas, you can use a cell reference to refer to:
• Data from one or more contiguous cells on the worksheet.
• Data contained in different areas of a worksheet.
• Data on other worksheets in the same workbook.
Q 7. What is Hyperlinks?
Ans: 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.
An absolute link will stop working only if the target is moved.
A relative link will stop working only if the start and target locations
change relative to each other.
The Hyperlink icon on the Standard toolbar or
choose Insert > Hyperlink from the menu bar.
Q 8. How to SHARING WORKSHEET DATA.
Ans: Spreadsheet software allows the user to share the workbook and
place it in the network location where several users can access it simultaneously.
At any time, you can set up a spreadsheet for sharing with others.
With the spreadsheet document open, choose Tools > Share Document to activate
the collaboration features for this worksheet. A dialog opens where you can
choose to enable or disable sharing.
Q 9. How can we rename a worksheet?
Ans: There are three ways you can rename a worksheet, and the only difference between them is the way in which you start the renaming process. You can do any of the following:
Double-click on one of the existing worksheet names.
• Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
• Select the worksheet you want to rename (click on the worksheet tab) and then
• select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Q 10. What are the two ways of referencing cells in other worksheets? Ans:
1. Creating The Reference With The Mouse
• Click on the = icon next to the formula bar. The icons change and an equals sign.
• Now, click on the sheet tab for the sheet containing the cell to be referenced.
• Click on cell F3 (where the balance is) in the Checking Account sheet. The phrase ‘Checking Account’.
• Click the green checkmark in the formula bar to finish.
2. Creating The Reference With The Keyboard
Typing the reference is simple once you know the format the reference takes. The reference has three parts to it:
∙ Path and file name
∙ Sheet name
∙ Cell Looking at the figure above, you can see the general format for the reference is =’file:///Path &File Name’#$SheetName.CellName.
Q 11. Differentiate between relative and absolute hyperlinks. Ans: An absolute link will stop working only if the target is moved.
A relative link will stop working only if the start and target locations change relative to each other.
Q 12. Fill up the blanks.
a. At the bottom of each worksheet window is a small tab that indicates the name of the worksheets in the workbook.
b. 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.
Q 13. What is Macro?
Ans: A macro is a saved sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that “types” your address.
The OpenOffice.org (OOo) macro language is very flexible, allowing automation of both simple and complex tasks. Macros are especially useful to repeat a task the same way over and over again.
Q 14. How Macro to be record Macro ?
Ans: The following steps create a macro that performs paste special with multiply.
1. Open a new spreadsheet.
2. Enter numbers into a sheet
3. Select cell A3, which contains the number
3, and copy the value to the clipboard.
4. Select the range A1:C3. 5. Use Tools > Macros > Record Macro to
start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
Q 15. a. Macros are useful to repeat a task the same way over and over again.
No comments:
Post a Comment