Information Technology
Class-10
Part-B
Unit- 2 Electronic Spreadsheet (Advanced)
PART-II
C. Short Answer type Questions:
1. What is consolidating of data?
Answer: To summarize and view results from different worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet or in other workbooks.
2. Write the steps to create subtotals in a worksheet.
Answer: To create subtotals in a Microsoft excel worksheet, you can follow these steps:
1. Organize the data in your worksheet.
2. Select a cell in your data set.
3. Go to the data tab and click subtotal in the outline group.
4. In the subtotal dialog box, specify the following: Column to group by, Summary function, Columns to subtotal.
5. Click OK.
3. What is the use of what if scenario?
Answer: By using What-If analysis tools in MS-Excel, you can use several different sets of values in one or more formulas to explore all the various results.
4. What is the use of Goal Seek?
Answer: Goal Seek is a tool that helps you find the input value needed to achieve a desired result from a formula. Goal Seek is a type of what if analysis that's useful in financial modeling and other financial analysis.
It is also useful for:
* Determining the interest rate needed for a loan.
* Calculating the score needed on a test to earn a desired grade.
* Determining the score needed on a final exam to pass a class.
5. What is the use of Solver?
Answer: Solver is a Microsoft excel add-in program you can use for what-if analysis. It can solve for a maximum value of a number, a minimum value of a number or an exact number. It works within constraints so if one variable can't be changed or can only vary within a specified range, solver will take that into account.
6. Write the steps of using Goal Seek.
Answer: Steps to use Goal Seek excel:
1. Put the cursor on the cell that contains the output you want to change.
2. On the data ribbon, select what-if analysis, then select Goal Seek.
3. When the dialog box appears make "Set cell" equal to the revenue cell.
4. Set "To value" equal to the output you want to achieve.
5. Set "By changing cell" equal to the assumption you want to solve.
6. Press OK.
7. Write the steps of using Solver.
Answer: To use solver in excel you can:
1. Load the solver add-in.
2. Click data>solver
3. Define the problem.
4. In the solver parameters dialog box, click options.
5. Select the show iteration results check box.
6. Click ok.
7. Click solve.
8. Click stop to stop the solution process and display the solver result.
9. Click continue to continue the solution process and display the next trial solution.
8. What is a hyperlink?
Answer: Hyperlink is a clickable icon, graphic, or underlined phrase that directs to another resource or web page.
Here are some types of hyperlinks:
* Text hyperlink
* Image hyperlink
* Bookmark hyperlink
* Internal link
* Fat link
9. What are the types of hyperlinks?
Answer: Here are some types of hyperlinks:
* Text hyperlink
* Image hyperlink
* Bookmark hyperlink
* Internal link
* Fat link
10. What is the difference between absolute and relative hyperlinks?
Answer:
Absolute Hyperlinks: An absolute hyperlink in MS Excel includes a complete address. It contains a protocol and domain name for a sued URL, including the full path and the documents file name.
Relative Hyperlinks: A relative hyperlink in MS Excel includes a partial address without protocol and domain name for URL.
11. How can you link a worksheet to external data?
Answer: Steps to link an excel worksheet to external data:
1. Open an excel workbook
2. Select data>get data
3. Choose the source you want to connect to from the drop-down menu.
4. Select the file to import from the import data dialog box.
5. Click open to start the import process.
6. Select the table to import from the database.
7. Click load to import the data.
8. Click close and load to finish.
12. What is sharing of a worksheet?
Answer: Sharing a worksheet allows multiple users to access and work on the same file simultaneously. This can be useful for teams to work to gather on a single document, or to collect information for surveys.
13. Write the steps of sharing a spreadsheet.
Answer: The steps for sharing a spreadsheet vary depending on the program you're using, but generally involve the following steps:
* Open the file: Open the file you want to share.
* Enter recipients: Enter the email addresses or groups you want to share with.
* Set permissions: Choose the level of access you want ot give people.
* Send: Click send.
14. What is the meaning of track changes?
Answer: Track changes is a Microsoft word feature that records and high lights edits made to a document. It is particularly useful for documents with multiple authors.
15. How can you insert comments in a spreadsheet?
Answer: Right click on the cell, then select insert comment. You can also press Shift+F2. To edit a comment, right click on the cell and select edit comment. To delete a comment, right click on the cell and select delete comment.
16. What is merging of worksheets?
Answer: Merging in a spreadsheet is the process of combining two or more cells or spreadsheet to create a single entity.
17. How can you merge two worksheets in a single worksheet?
Answer: You can merge two worksheets in a single worksheet using different ways.
Consolidate Date: Open the source sheets, then in the destination sheet, select the upper lef cell where the consolidated data will appear. Go to Data>Consolidate.
18. How can you compare two worksheets?
Answer: There are multiple ways to compare worksheets in excel:
View side by side: This method is good for small workbooks.
1. Click new window in the window group on the view tab.
2. Click view side by side in the window group on the view tab.
3. Click the sheet you want to compare in each workbook window.
4. Click synchronous scrolling to scroll both worksheets at the same time.
19. What is a macro?
Answer: A macro is a set of instructions or commands that are grouped together to automate a task. Macros can be used in various programs including Microsoft excel, Microsoft access etc.
20. How can you record a macro?
Answer: To record a macro in Microsoft Excel, follow the steps:
1. Enable the developer tab.
2. Click record macro in the code group on the developer tab.
3. Perform the actions you want to record.
4. Click stop recording.
21. How can you pass arguments to a macro?
Answer: To use a macros that expects arguments, you write the name of the macro followed by a list of actual arguments in a parentheses, separated by commas. The number of actual arguments you give must match the number of arguments the macros expects. Examples of use of the macro min include min (1,2) and min (x+27,*p).
22. How can you sort a single column using macro?
Answer: If you want to sort column A, you need to use key:=Range(''A1") order- here you specify whether you want the sorting in an ascending order or the descending order. For example, if you want the sorting in ascending order, you will use Order:=xlAscending.
D. Long Answer Type Questions:
1. Explain the process of consolidating data using subtotals with the help of a worksheet.
Answer: To consolidate data using subtotals in a worksheet, you can use the subtotal command in Microsoft Excel:
1. Select the data tab.
2. In the outline group, click subtotal.
3. In the at each change in box, select the column to subtotal.
4. In the use function box, select the summary function to calculate the subtotals.
5. In the add subtotal to box, select the check box for each column that contains values to subtotal.
6. To add more, subtotals, repeat steps one through seven.
7. To avoid overwriting existing subtotals, clear the replace current subtotals check box.
2. Explain the use of what if scenario with the help of example.
Answer: What-if scenarios are a way to consider how changes in one thing effect another. Here are some examples of what-if scenarios:
Business: A company can use what-if scenarios to determine how many employees to hire, how much material to use, or how to price a product. For example, a company might ask what would happen to revenue if they charged more for a product.
3. What is hyperlink? Explain the types of hyperlinks with the help of a worksheet example.
Answer: A hyperlink, also known as a link or hot link, is a click-able area on a web page that takes the user to another page, file, or document. Here are some different types of hyperlinks:
* Text hyperlink: Uses a word or phrase to take the user to another page.
* Image hyperlink: Uses an image to take the user to another page.
* Bookmark hyperlink: Uses text or an image to take the user to another part of a webpage.
* E-mail hyperlink: Allows the user to send an email message to the displayed email address.
* Internal hyperlink: Links to a different page or resource within the same website or domain.
* External hyperlink: Links to a different website or domain than the one the user is currently visiting.
4. Write the steps of sharing worksheets to other users. How will your review changes in a shared document?
Answer: To share a worksheet with other users in excel and review changes, you can do the following:
Share the worksheet:
1. Open the file.
2. Click share in the upper right corner.
3. Click invite people.
4. Enter the names or email addresses of the people you want to share with.
5. Select send or copy link.
Review changes:
1. Go to the review tab.
2. Click track changes in the changes group.
3. Click highlight changes.
4. Select the changes you want to see.
5. You can also collapse the dialog to select a range on the sheet.
5. Explain the steps of recording and running a macro.
Answer: Here are the steps to record and run a macro in excel:
Record the macro:
1. Go to the developer tab.
2. Click record macro in the code group.
3. Name the macro.
4. Assign a shortcut key.
5. Select where to store the macro.
6. Click OK to start recording.
7. Perform the actions you want to record.
8. Click stop recording in the code group.
Run the Macro:
1. Go the developer tab.
2. Click macros.
3. Select the macro you want to run.
4. Click run.
Some other links:
No comments:
Post a Comment