Unit- 7 Electronic Spreadsheet (Advanced)
Chapter- 16 Linking, Sharing and Macros in Excel
I. Multiple Choice Questions. Tick the correct answer.
1. Which of these tabs contains the option to enable sharing of an Excel workbook?
a. Insert tab b. Sheet tab c. Review tab d. Data tab
Answer: Review tab
2. Which of these help us to manage multiple sheets in a spreadsheet file?
a. Menus b. sheet tabs c. edit tab d. toolbars
Answer: Sheet tabs
3. Which tab contains track changes related options in MS Excel?
a. file tab b. tools tab c. view tab d. review tab
Answer: Review tab
4. To insert a sheet in a spreadsheet file, right click on a sheet tab and from the context menu select the ____ option.
a. Add sheet b. Insert c. New sheet d. Excel sheet
Answer: Insert
5. Which is the correct formula for creating cell reference?
a. ='sheet name'!cell_reference b. ='spreadsheet name'.cell_reference
c. ='sheet name';cell_reference d. ='spreadsheet name':cell_reference
Answer: ='sheet name'!cell_reference
6. Which of the following is a valid way to add a sheet to an Excel file?
a. Click on insert sheet button b. Select insert--->sheet from context menu
c. Both (a) and (b) d. Neither (a) nor (b)
Answer: Both (a) and (b)
7. Which type of hyperlink contains the full address of an internet resource?
a. relative link b. absolute link c. data link d. none of these
Answer: Absoluter link
8. Each user who wants to collaborate should be sure to enter a name on which of the following?
a. in the edit tab of the share workbook dialog box
b. in the tools tab of the record macros dialog box
c. in the scenario manager dialog box
d. none of these
Answer: In the tools tab of the record macros dialog box
9. What do we call a saved sequence of commands or keystrokes which are saved by MS Excel for later use?
a. objects b. macros c. values d. formulas
Answer: Macros
10. Which macro option is the best if you want to run only those files which contain macros from trusted sources?
a. Disable all macros without notification
b. Disable all macros with notification
c. Disable all macros except digitally signed macros
d. None of these
Answer: Disable all macros except digitally signed macros
II. Fill in the blanks:
1. When we open a new workbook in Excel, it has____ worksheets by default.
Answer: Three
2. To open the _______ dialog box right click on the sheet before which you want to insert a new sheet.
Answer: Insert
3. Excel allows a number of users at a time to open a same ____ for viewing and editing.
Answer: Spreadsheet
4. Once you close a workbook file excel____ all the macros it contains.
Answer: Disables
5. We can easily create _____of the cells of one sheet on to a second sheet using both the keyboard and mouse.
Answer: Reference
6. While creating a reference from one workbook into another workbook using the mouse both the _____must be open.
Answer: Workbooks
7. Always remember to put a ______ mark between the sheet name and cell reference in a reference formula.
Answer: Exclamation
8. A _______ hyperlink is a hyperlink that contains an address that is relative to the address of the destination file.
Answer: Relative
9. Excel automatically adds to any recorded change a _____ that describes what was changed in the cell.
Answer: Comment
10. A ____ is a saved sequence of commands or keystrokes that are stored for later use.
Answer: Macro
Some other Links:
No comments:
Post a Comment