EL1 C6 Flashcards
Will moving a worksheet from one workbook to another affect formulas in the source workbook that are not on the sheet that is moved?
Yes, if the formulas depend on the contents of cells in the sheet that was moved
To modify a cell style, begin by clicking the Cell Styles button in the _____ group on the _____ tab.
Styles; Home
What happens when you clear the contents of the Recent option list?
The list is emptied, except for pinned workbooks
If you are creating a hyperlink to a cell within the same worksheet, what do you enter in the Type the cell reference text box at the Insert Hyperlink dialog box?
the cell name being linked to
When moving a worksheet to another workbook, start by performing which of the following steps?
Open both the source and destination workbooks
To remove a style from cells, select the cells, click the Cell Styles button, and then click the _____ style at the drop-down gallery.
Normal
You can insert a hyperlink in a workbook for each of the following purposes except…
to copy data from another workbook
How do you make the Edit button appear in a comment?
Click in the cell and then position the mouse pointer inside the comment box
From the New backstage area, click a template to preview it, and click the _____ button to open a new document based on the template.
Create
To define a style with existing formatting, select the cell or cells containing the formatting and then perform which of the following steps?
Click the Cell Styles button in the Styles group on the Home tab and then click the New Cell Style option at the drop-down gallery
The _____ function finds the payment for a loan based on constant payments and a constant interest rate.
PMT
You can apply a style from the _____ button drop-down gallery or create a new style.
(?)
To display installed templates, click the _____ tab and then click the _____.
File; New option
To apply a style, select the cell(s) to which the style will be applied, click the Cell Styles button in the Styles group and then…
pick a style from the drop-down gallery
To link an Excel workbook to a workbook or file in another application, display the Insert Hyperlink dialog box and then click the _____ or _____ button in the Link to section.
Existing File; Web Page
To enter information in placeholders in a worksheet, move the insertion point by pressing _____ to make the next cell active and _____ to make the previous cell active.
the Tab key; Shift + Tab
You can copy styles from one workbook to another at the…
Merge Styles dialog box.
To insert a comment in a cell using the shortcut menu, right-click the cell and then click the _____ option at the shortcut menu.
New Comment
If you delete a style from the Cell Styles gallery, what will happen?
Formatting applied by the deleted style will be removed from all the cells in the worksheet
When copying a worksheet from one workbook to another, which of the following steps is not performed at the Move or Copy dialog box?
Select the name of the source workbook
You can “unpin” a workbook from the Recent option list by _____ the workbook name and then clicking the Unpin from list option.
right-clicking
Which of the following is not one of the advantages of using a style to apply formatting to cells?
Doing so allows you to apply formatting attributes that are not available without a style
What displays when you hover the mouse pointer over a hyperlink?
a ScreenTip with the address of the hyperlinked location
To create a hyperlink to an email address, click the E-mail Address button in the _____ section of the Insert Hyperlink dialog box.
Link to
How do you create a hyperlink with a graphic?
Select the graphic, click the Insert tab, and then click the Link button
To view all comments at a glance, open the _____ by clicking the Show Comments button in the Comments group on the Review tab.
Comments task pane
To define a custom style without first applying formatting, begin by displaying the _____ dialog box.
Style
Which of the following arguments is the present value of an investment, expressed in a lump sum?
PV
Excel provides a number of financial _____, such as PMT, that can be used in formulas.
Functions
The styles you define in a workbook are available…
only in that workbook
To copy a worksheet from one workbook to another, begin by opening…
both the source and the destination workbooks
The _____ function calculates the future value of a series of equal payments or an annuity.
FV
Hover the mouse pointer over a style in the _____ button drop-down gallery and the cell or selected cells display with the formatting applied.
Cell Styles
Close the Comments task pane by clicking the _____ button in the task pane or by clicking the _____ button.
Close; Show Comments
A predefined set of formatting attributes (such as font size, alignment, borders, and so forth) is called a…
cell style
Generally, the names of the _____ most recently opened workbooks display in the Recent option list.
50
A _____ is a pop-up box that is attached to a cell and contains text pertaining to the contents of the cell.
comment
When you “pin” a workbook in Excel, what are you pinning it to?
the Recent option list
If a worksheet contains the annual percentage rate (APR), enter the cell reference in the function argument and specify that it should be divided by…
12 months
What is a template worksheet form?
a form preformatted for specific uses (balance sheet, sales invoice, etc.) that can be used when creating a new workbook
To delete all the comments in a thread, click the _____ button and then click Delete thread at the drop-down list.
Thread options
A list of the most recently opened workbooks is available in several places but not at…
the Print backstage area
When you click the Recover Unsaved Workbooks button, the _____ dialog box displays with the names of the workbooks that Excel has saved automatically.
(?)
What happens if you delete the Normal cell style?
The Normal style cannot be deleted
To modify a hyperlink, begin by _____ the hyperlink.
right-clicking
By default, the automatic formatting of hyperlinks is turned on; you can turn this off at the _____ dialog box.
AutoCorrect
To insert a hyperlink, begin by clicking the _____ tab and then click the Link button in the _____ group.
Insert; Links
Insert and manage comments with buttons in the _____ group on the _____ tab.
Comments; Review
Where do you edit the text of a hyperlink you have already inserted?
in the cell
