Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL2 C5 C6 > Flashcards

EL2 C5 C6 Flashcards

1
Q

Excel’s built-in auditing features help you make sure that

A

a worksheet is functioning accurately

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

Use Excel’s _____ feature to test data that was entered before validation rules were set up.

A

Circle Invalid Data

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

At the Scenario Summary dialog box, enter in the Result cells text box

A

the formula cell or cells that change when the data is applied in various scenarios

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

To test the accuracy of key figures in a worksheet, enter a _____ outside the main worksheet area.

A

proof formula

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

You can do all the following at the Paste Special dialog box except

A

copy the active cell, plus all others with the same value

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

To use the Scenario Manager, start by clicking the Data tab and then the_____ button.

A

What-If Analysis

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

Which of the following is not one of the Excel error codes mentioned in Chapter 5?

A

a red diagonal triangle

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

Which types of data tables does Excel offer?

A

one-variable and two-variable

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

A range of cells in a copied source range can be multiplied by the cells in the destination range by

A

using Paste Special and clicking Multiply

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

To create a data table, begin by clicking the _____ button.

A

What-If Analysis

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

What advice does Chapter 5 give regarding creating scenarios?

A

create the first scenario using the original values

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

Which of the following buttons is not available at the Scenario Manager dialog box?

A

OK

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

When you select Formats at the Paste Special dialog box, Excel will paste

A

only formatting options from the source

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

Cells that contain formulas that reference other cells are called _____ cells.

A

Dependent

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

Which of the following options is not provided at the What-If Analysis button drop-down list

A

Evaluate Formula

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

You can convert data from a column to a row arrangement by clicking the Transpose button at the Paste button drop-down gallery or by clicking the Transpose option

A

at the Paste Special dialog box

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

After data has been copied to the Clipboard, use options at the _____ dialog box to perform a mathematical operation in the destination range based on values in the source range.

A

Paste Special

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

With a large worksheet, you can keep track of dependent cells that may not be visible while other cells are being changed by

A

opening a Watch Window

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

When using the Goal Seek command, enter the target value into the _____ box at the Goal Seek dialog box.

A

To value

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

To clear cell tracer arrows, click the _____ button.

A

Remove Arrows

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

The _____ error code indicates that the formula contains an unrecognized entry.

A

NAME?

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

When viewing the results of a scenario at the Scenario Manager dialog box, click the _____ button to apply the current values.

A

Show

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

The cell in which Excel is to calculate the target value using Goal Seek must be referenced by a formula in the _____ text box.

A

Set cell

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

Which of the following is not one of the options in the Operation section of the Paste Special dialog box?

A

Count

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

How many models can you create using the Scenario Manager dialog box?

A

As many as you want

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

Convert data in columns to rows and vice versa using the _____ button in the Paste button drop-down gallery or using the _____ option at the Paste Special dialog box.

A

Transpose; Transpose

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

Use the _____ button to work through a formula value by value to determine where an error exists.

A

Evaluate Formula

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

To test three different what-if conditions using the Scenario Manager, you must

A

create three scenarios

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

What can you do to see a descriptive reference next to the input text box, rather than the cell address when adding a scenario?

A

Create a range name for each changing cell

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

Use the _____ option at the Paste Special dialog box to convert data arranged in rows to data arranged in columns.

A

Transpose

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

To circle invalid data, click the _____ button arrow and then click the Circle Invalid Data option.

A

Data Validation

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

To calculate a value, the Goal Seek feature requires that cells have a(n) _____ relationship.

A

dependent

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

With a Watch Window, you can keep track of multiple

A

dependent cells

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

How is the Scenario Manager different from the Goal Seek feature?

A

It allows you to examine several different answers to your question

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

If you hear a beep while tracing cell relationships, it means that

A

no more relationships exist

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

Use Excel’s _____ feature when you know the result but don’t know what input value will achieve that result.

A

Goal Seek

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

Enter _____ in the Changing cells text box at the Add Scenario dialog box.

A

the range cells that will change when the scenario is applied

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

To compare scenarios side by side, display the Scenario Manager dialog box and click the _____ button.

A

Summary

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

By default, Excel stores _____ in the Comment text box at the Add Scenario dialog box.

A

the user name and date the scenario was created

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

Cells that provide data to formula cells are called _____ cells.

A

precedent

41
Q

Using data tables provides a means of analyzing various outcomes in a calculation without

A

creating multiple formulas

42
Q

In a two-variable data table, where is the source formula placed?

A

in the top left cell of the table

43
Q

The _____ group on the Formulas tab contains buttons that are useful for viewing relationships between cells in formulas.

A

Formula Auditing

44
Q

Which of these is not a file extension for a text file?

A

.tab

45
Q

Use the _____ function to join the content of two or more cells, including text, numbers, and cell references.

A

CONCAT

46
Q

The text function PROPER

A

capitalizes the first letter of each word

47
Q

What does it mean if a yellow triangle with an exclamation mark appears next to a query in the Queries & Connections group?

A

The source file cannot be found

48
Q

What will be returned by the formula =LEFT(“1st Quarter Sales”,3)?

A

1st

49
Q

What is the keyboard shortcut for using the Flash Fill feature?

A

Ctrl + E

50
Q

If cell A3 holds the text JD Enterprises, the formula =LEN(A3) will return which of the following?

A

14

51
Q

To exchange Excel data with someone who does not have Excel, save the workbook as a

A

text file

52
Q

To start the process of exporting data from Excel to Access, open the Excel workbook, select the cells to export, _____, and then start Access.

A

click the Copy button

53
Q

When data is imported into Excel, the data is imported in a table format and a(n) ____ is created.

A

query

54
Q

If the Excel data being exported to Word will often change and you want to keep the Word document up to date, copy the data to the Clipboard in Excel, open Word, place the insertion point in the desired location,

A

click the Paste button arrow, click Paste Special, click Microsoft Office Excel Worksheet Object, and then click Paste link

55
Q

Before transferring data from Excel to an existing table datasheet in Access, make sure that

A

the column structures in the two programs matc

56
Q

To redisplay the Query & Connections task pane,

A

click the Queries & Connections button

57
Q

UPPER and RIGHT are both _____ functions.

A

Text

58
Q

You can import data into Excel from a variety of sources. Which of the following is not one of the sources discussed in Chapter 6?

A

PowerPoint

59
Q

The formula =RIGHT(“1st Quarter Sales”,5) will return _____ in formula cell.

A

Sales

60
Q

Flash fill can be used to

A

join parts of the contents of cells

61
Q

In a tab delimited text file, Excel _____ at each tab.

A

begins a new column

62
Q

To use Excel’s editing features to edit data embedded in Word, copy cells to the Clipboard in Excel, open Word, place the insertion point in the desired location,

A

click the Paste button arrow, click Paste Special, and then click Microsoft Office Excel Worksheet Object

63
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

64
Q

When you edit an Excel chart embedded in a PowerPoint presentation,

A

the groups and buttons available on the Excel chart tabs become active

65
Q

The formula =MID(“JD Enterprises Inc.”4,11) will return _____ in the formula cell.

A

Enterprises

66
Q

Use _____ functions to extract the data when only some of the characters in a cell need to be copied.

A

Text

67
Q

The TEXTJOIN function uses a ____ delimiter.

A

constant

68
Q

One of the options at the _____ dialog box is to have Excel refresh the data when you open the file.

A

Query Properties

69
Q

To separate a field into two fields during an import process, click the Edit button, select the column to be split, and then

A

click the Split Column button in the Transform group

70
Q

To open a non-native file directly in Excel, use the _____ option to navigate to a specific folder and then click the File Type option box to display a drop-down list of all the files types that Excel can open.

A

Browse

71
Q

Use the Power Query Editor window to

A

transform data before it is imported into Excel

72
Q

What should you do to refresh a query?

A

Click the Refresh All button in the Queries & Connections group

73
Q

Once Flash Fill has recognized that the first word of the adjacent column is to be extracted and suggests doing the same for the remaining cells, you should _____ to accept the suggestion or continue typing to reject the suggestion.

A

press the Enter key

74
Q

The formula =CONCAT(“-“,519,555,1234) will return which of the following?

A

-5195551234

75
Q

At the Import Data dialog box, which of the following is not one of the options for viewing imported data in a workbook?

A

Excel Chart

76
Q

At the Query Properties dialog box, click the Refresh every check box to insert a check mark and then adjust the number of minutes in the measurement box if you want to Excel to

A

refresh the query at a specific time period

77
Q

What does the text function SUBSTITUTE do?

A

inserts new text in place of old text

78
Q

From where do you delete a scenario?

A

the Scenario Manager dialog box

79
Q

Which of these options is not found in the Paste section of the Paste Special dialog box?

A

As hyperlink

80
Q

If you see a green diagonal triangle in the upper left corner of a cell, you should activate the cell and then

A

(?)

81
Q

A link to Excel data from a Word document will no longer work if you _____ the source workbook.

A

move or rename

82
Q

How many Access tables can be imported into Excel at a time?

A

one

83
Q

One of the methods for deleting a query is to right-click the query at the _____ and then click the Delete option at the pop-up menu.

A

Queries & Connections task pane

84
Q

The formula =TEXTJOIN(“-“,TRUE,519,555,1234) will return which of the following?

A

519-555,1234

85
Q

Why are text files useful for sharing data with others?

A

The text file format is supported by almost all applications and computers

86
Q

If you have linked an Excel object to a Word document and decide to keep the data but not maintain the link,

A

open the Word document, right-click the linked object, point to Linked Worksheet Object, click Links, and then click the Break Link button

87
Q

To export Excel data to an Access database that does not have an existing table in which to receive the data, you should

A

perform an import routine from Access

88
Q

Which of these is not a text file format supported by Excel?

A

.bin

89
Q

To import a text file into Excel, use the _____ button in the _____ group.

A

From Text/CSV; Get & Transform

90
Q

To import an Access table into a new worksheet after selecting the table at the Navigator dialog box, begin by clicking the _____ button.

A

OK

91
Q

To finish the process of exporting data from Excel to Access, open the Access database in Datasheet view,

A

click the Paste button arrow, click Paste Append, and then click Yes

92
Q

Import data into Excel using buttons in the _____ group on the _____ tab.

A

Get & Transform Data; Data

93
Q

To test the various inputs on the worksheet model in the Scenario Manager, you can

A

switch scenarios

94
Q

Removing the connection between the source file and the destination file allows which of the following?

A

capturing the data at a specific time

95
Q

When tracing relationships between cells and formulas, Excel draws _____ if an error is detected.

A

red tracer arrows

96
Q

You must provide three pieces of information via a dialog box when using the Goal Seek command. Which of the following is not one of them?

A

confidence level

97
Q

A range of cells containing a series of input values is called a

A

data table

98
Q

If the data being copied from Excel to Word is not likely to need editing or updating, copy it to the Clipboard in Excel, open Word, place the insertion point in the desired location,

A

and then click the Paste button

99
Q
A

ETM 1030 (18 decks)

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