EL1 C6 Flashcards
(49 cards)
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
