NEW
Font size
WorksheetsW5- 11/04
Total questions: 10
Worksheet time: 5mins
Evelyn wants to work on different parts of a workbook at the same time by displaying worksheets in separate windows. Which option on the View tab should she select?
Arrange All
New Window
Zoom
Page Break Preview
To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.
master
model
template
standard
Ricki has an Analysis workbook containing many worksheets of sales data that she wants to use in a new workbook. What is the easiest way for her to use the sales data in the new workbook?
Copy the cells containing sales data to the new workbook.
Insert hyperlinks from the Analysis workbook to the new workbook.
Copy the worksheets from the Analysis workbook to the new workbook.
Hide the worksheets in the Analysis workbook.
Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?
Create a custom view of the worksheets.
Group the worksheets.
View the worksheets side by side.
Link the worksheets.
A _____ is text or an image you click to open a webpage or file.
3-D reference
Hyperlink
ScreenTip
Template
Which of the following techniques can you use to remove hyperlink from a cell?
Click the Clear button on the Home tab and then click Remove Hyperlink.
Click the Clear button on the Home tab and then click Remove Hyperlink.
Right-click the hyperlink and then click Restore on the shortcut menu.
Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu.
Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?
Add a description.
Add a ScreenTip.
Change the Link to location.
Add a HyperTip.
How do you select a cell containing a hyperlink without activating the link?
Double-click the cell.
Right-click the cell.
Click the cell and then click Do Not Activate.
Click the cell and then click Edit Hyperlink.
What happens when you click a link to a Word document while working in Excel?
Excel displays the Word document within Excel.
Excel closes, and then Word starts so you can navigate to the document.
Word starts and opens the linked document.
Your default browser opens and displays the Word document.
A workbook template has which of the following file extensions?
.xltx
.xls
.xlsx
.xlst
