Excel Ch 6
comment
A cell that contains a _ will show a colored icon in the upper corner, alerting the reader that it exists
a graphic or an email address
A hyperlink can be inserted using which of the following?
to save a file
A hyperlink in a workbook cannot be used for which of the following purposes?
selected cells
At the Cell Styles button drop-down, hover the mouse pointer over a style and the _ display with the formatting applied.
Before sheet
At the Move or Copy dialog box, click the name of a worksheet in the _ section adn the moved or copied workshop in inserted before it.
Cell styles
Click the _ button to display a gallery of predesigned cell styles, which include font, font size, alignment, borders, shading, and other attributes.
Merge style
Copy styles from one workbook to another at the _ dialog box.
style
Define a cell style with formats already applied to a cell at the _ dialog box.
new
Display installed templates in Excel by clicking the File tab and then clicking the _ option
50
Generally, how many workbook names are displayed in the list of recently opened workbooks?
Right-click the hyperlink and then click Edit Hyperlink at the shortcut menu
How can you modify a hyperlink?
The text is blue and underlined
How can you tell whether a web address is formatted as a hyperlink?
Click the Recover Unsaved Workbooks button below the Recent list
If you close a workbook without saving it, how can you recover it?
ScreenTip
If you hover the mouse pointer over a hyperlink, a(n) _ displays.
pin the workbook name
If you want a workbook name to remain at the top of the Record option list, you should
placeholders
In Excel templates, locations for personalized text are shown in _ in the worksheet.
row number; column letter
In the Comments task pane comments appear in order first by _ and then by _
recent
In the Open backstage area, the names of the most recently opened workbooks are displayed in the _ option list.
post
Once a comment is typed into the text box of the comment pop-up box, click the _ button to add the comment
PMT
The _ function calculates the payment for a loan based on constant payments and constant interst rate.
only in the workbook in which they are created
The cell styles you create are available
opening
To copy worksheet to another workbook, begin by _ both the source and the destination workbooks.
the Create New Document button in the Link to section at the Insert Hyperlink dialog box
To create a hyperlink to a new workbook, begin by clicking which of the following?
style
To define a custom style swithout first applying formatting, begin by displaying the _ dialog box.
Move or Copy
To move a workbook to another workbook, open both the source and the destination workbooks, make active the worksheet to be moved in the source workbook, right-click the sheet tab, and then click _ at the shortcut menu.
Remove Hyperlink
To remove a hyperlink from a workbook, right-click the cell containing the hyperlink and the click _ at the shortcut menu.
FV
Use the _ function to determine information such as how much money can be earned in an investment with a specific interest rate and specific period of time.
the future value of a series of equal payments or an annuity
What does the FV function calculate?
the current workbook
Whe you modify a predesigned style, the style in _ is affected.
all the cells update automatically
When cells have been formatted with a style, what happens when the formatting is modified?
style
When defining a custom style without first applying the formatting, at the _ dialog box, remove the check mark from ant format that should not be included in the style and then click OK to close the dialog box.
They automatically reflect the new formatting
When you modify the formatting of a style, what happens to cells to which the style was applied?
The formulas will no longer work properly
When you move a worksheet to another workbook, what happens if there are formulas in the original workbook that depend on the contents of cells in the worksheet that is moved?
the Normal cell style
Which of the following cell style cannot be deteccted?
Nv
Which of the following is not one of the arguments used in financial functions?
Normal
Which of the following is the default cell formatting the Excel?
delete comment
You can delete a comment by clicking the Delete button in the Comment group on the Review tab or by using the _ option at the shortcut menu
