Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > EL1 C6 > Flashcards

EL1 C6 Flashcards

1
Q

Will moving a worksheet from one workbook to another affect formulas in the source workbook that are not on the sheet that is moved?

A

Yes, if the formulas depend on the contents of cells in the sheet that was moved

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

To modify a cell style, begin by clicking the Cell Styles button in the _____ group on the _____ tab.

A

Styles; Home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What happens when you clear the contents of the Recent option list?

A

The list is emptied, except for pinned workbooks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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?

A

the cell name being linked to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When moving a worksheet to another workbook, start by performing which of the following steps?

A

Open both the source and destination workbooks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

To remove a style from cells, select the cells, click the Cell Styles button, and then click the _____ style at the drop-down gallery.

A

Normal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You can insert a hyperlink in a workbook for each of the following purposes except…

A

to copy data from another workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How do you make the Edit button appear in a comment?

A

Click in the cell and then position the mouse pointer inside the comment box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

From the New backstage area, click a template to preview it, and click the _____ button to open a new document based on the template.

A

Create

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

To define a style with existing formatting, select the cell or cells containing the formatting and then perform which of the following steps?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The _____ function finds the payment for a loan based on constant payments and a constant interest rate.

A

PMT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You can apply a style from the _____ button drop-down gallery or create a new style.

A

(?)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

To display installed templates, click the _____ tab and then click the _____.

A

File; New option

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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…

A

pick a style from the drop-down gallery

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

A

Existing File; Web Page

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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.

A

the Tab key; Shift + Tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You can copy styles from one workbook to another at the…

A

Merge Styles dialog box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

To insert a comment in a cell using the shortcut menu, right-click the cell and then click the _____ option at the shortcut menu.

A

New Comment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

If you delete a style from the Cell Styles gallery, what will happen?

A

Formatting applied by the deleted style will be removed from all the cells in the worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

When copying a worksheet from one workbook to another, which of the following steps is not performed at the Move or Copy dialog box?

A

Select the name of the source workbook

21
Q

You can “unpin” a workbook from the Recent option list by _____ the workbook name and then clicking the Unpin from list option.

A

right-clicking

22
Q

Which of the following is not one of the advantages of using a style to apply formatting to cells?

A

Doing so allows you to apply formatting attributes that are not available without a style

23
Q

What displays when you hover the mouse pointer over a hyperlink?

A

a ScreenTip with the address of the hyperlinked location

24
Q

To create a hyperlink to an email address, click the E-mail Address button in the _____ section of the Insert Hyperlink dialog box.

A

Link to

25
Q

How do you create a hyperlink with a graphic?

A

Select the graphic, click the Insert tab, and then click the Link button

26
Q

To view all comments at a glance, open the _____ by clicking the Show Comments button in the Comments group on the Review tab.

A

Comments task pane

27
Q

To define a custom style without first applying formatting, begin by displaying the _____ dialog box.

A

Style

28
Q

Which of the following arguments is the present value of an investment, expressed in a lump sum?

A

PV

29
Q

Excel provides a number of financial _____, such as PMT, that can be used in formulas.

A

Functions

30
Q

The styles you define in a workbook are available…

A

only in that workbook

31
Q

To copy a worksheet from one workbook to another, begin by opening…

A

both the source and the destination workbooks

32
Q

The _____ function calculates the future value of a series of equal payments or an annuity.

A

FV

33
Q

Hover the mouse pointer over a style in the _____ button drop-down gallery and the cell or selected cells display with the formatting applied.

A

Cell Styles

34
Q

Close the Comments task pane by clicking the _____ button in the task pane or by clicking the _____ button.

A

Close; Show Comments

35
Q

A predefined set of formatting attributes (such as font size, alignment, borders, and so forth) is called a…

A

cell style

36
Q

Generally, the names of the _____ most recently opened workbooks display in the Recent option list.

A

50

37
Q

A _____ is a pop-up box that is attached to a cell and contains text pertaining to the contents of the cell.

A

comment

38
Q

When you “pin” a workbook in Excel, what are you pinning it to?

A

the Recent option list

39
Q

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…

A

12 months

40
Q

What is a template worksheet form?

A

a form preformatted for specific uses (balance sheet, sales invoice, etc.) that can be used when creating a new workbook

41
Q

To delete all the comments in a thread, click the _____ button and then click Delete thread at the drop-down list.

A

Thread options

42
Q

A list of the most recently opened workbooks is available in several places but not at…

A

the Print backstage area

43
Q

When you click the Recover Unsaved Workbooks button, the _____ dialog box displays with the names of the workbooks that Excel has saved automatically.

A

(?)

44
Q

What happens if you delete the Normal cell style?

A

The Normal style cannot be deleted

45
Q

To modify a hyperlink, begin by _____ the hyperlink.

A

right-clicking

46
Q

By default, the automatic formatting of hyperlinks is turned on; you can turn this off at the _____ dialog box.

A

AutoCorrect

47
Q

To insert a hyperlink, begin by clicking the _____ tab and then click the Link button in the _____ group.

A

Insert; Links

48
Q

Insert and manage comments with buttons in the _____ group on the _____ tab.

A

Comments; Review

49
Q

Where do you edit the text of a hyperlink you have already inserted?

A

in the cell

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions