Unit- 7 Electronic Spreadsheet (Advanced)
Chapter- 16 Linking, Sharing and Macros in Excel
Part-2
III. Short Answer Questions:
1. How will you insert a new blank sheet into an Excel document?
Answer: To insert new blank sheet into an Excel document follow the steps:
1. The fastest method is to click on the insert worksheet button given besides the sheet tabs. This instantly inserts a new sheet at that point, without opening the insert sheet dialog box.
2. To insert a new blank worksheet before any existing worksheet, select that worksheet and then, on the Home tab, in the cells group, click insert option, and then click the insert sheet option.
3. Click on the sheet tab to select the sheet before which you want to insert a new sheet. Right click on the selected sheet tab and from the context menu, select the insert option. This will open up the insert dialog box. Click on the general tab and select the worksheet option. Then click on OK button.
2. How will you insert sheets from another spreadsheet into your
excel file?
Answer: Follow the steps to insert sheet from another spreadsheet into your excel file.
1. Open the source and the target workbooks.
2. Open the sheet you want to copy/move by clicking on its sheet tab.
3. Click the home tab and then click the format button in the cells group.
4. In the move or copy dialog box, choose the target sheet from the to book dropdown list.
5. Click to enable the create a copy option at the bottom of the dialog box.
6. Click OK and excel will move or copy the sheet to the target workbook.
3. How will you rename a sheet? Write the complete steps.
Answer:
*Double click on the required sheet tab. The existing name will become highlighted. Just type in the new name and click in any empty area of the worksheet. The name will change on the sheet tab.
or
*Right click the sheet tab and select the rename option from the context menu. The sheet name will become highlighted. Replace the highlighted name by typing in a new name from the keyboard.
4. What does the track changes feature helps you to do in Excel?
Answer: To view the history worksheet after saving, you must display it again by selecting the list changes on a new sheet check box in the highlight changes dialog box. By using the track changes feature in excel for mac, you can track, maintain, and display information about the changes that are made to a shared workbook.
5. What do you understand by macros?
Answer: A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros are especially useful to repeat a task the same way over and over again.
6. How will you record and run a macro?
Answer: You can also run a macro by clicking on an object, graphic, or control. In addition, you can run a macro automatically whenever you open a workbook.
1. In the workbook containing macro, enter some numbers between 0 and 1.
2. Select all the numbers and open the developers tab. Select macros button from the code group. This will bring up the macro dialog box.
3. Select the macro that you wish to run from the macro name section and click on the run button.
4. All the selected numbers in the workbook will change to percentage format. You can also run the macro simply pressing the ctrl+p keys from the keyboard.
7. How can you enable the track changes feature in an Excel workbook?
Answer: To enable the track changes features in an excel follow the steps:
1. Go to the review tab.
2. In the changes group, click on the track changes option and select highlight changes.
3. In the highlight changes dialog box, check the option-Track changes while editing. This also shares your workbook.
4. Click OK.
8. How can you link your spreadsheet to an external data source?
Answer: Follow the steps to link spreadsheet to an external data source:
1. Open the excel document where the external data is to be inserted.
2. Open the Data tab and in get external data group, click on from access command button.
3. Select the required database file listed in the dialog box and click on the open button.
4. Select a required table from the select table dialog box that appears and click the OK button.
5. Select whether you want to put the data in the existing workbook or in a new workbook.
6. Click on OK button.
9. How would you create a reference in Excel using the keyboard?
Answer: Follow the steps to create a reference in excel:
1. Click to select the cell on the sheet where you want to create the reference. In the formula bar type the = equal sing.
2. Now, activate the sheet containing the cell to be referenced by clicking on its sheet tab.
3. Click on cell B9 in the credit card 2 sheet.
4. Click the enter checkmark button on the formula bar.
10. How can you change the status of a document from unshared to shared?
Answer: The tools>share document command can be used to switch the mode for a document from unshared to shared. However if you want to use a shared document in unshared mode, you need to save the shared document using another name or path.
Some other Links:
No comments:
Post a Comment