Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL2 C1 C2 > Flashcards

EL2 C1 C2 Flashcards

1
Q

How will numbers display when the format code is [Red];[Blue]?

A

Positive numbers will display in red; negative numbers in blue

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

To create your own number format, select _____ in the Category list box at the Format Cells dialog box with the Number tab selected.

A

Custom

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

Suppose you have a worksheet in which you enter monthly expense figures and compare them to monthly budget figures. To have an expense figure automatically display in red if it exceeds the budgeted amount, you should use

A

conditional formatting

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

Which of the following would you use to set up a filter to display the names of all US states beginning with the letter M?

A

M*

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

_____ formatting converts numbers to exponential notation (E + n).

A

Scientific

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

Which of these formatting Type options is not available for US English at the Format Cells dialog box with the Number tab selected?

A

Credit Card Number

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

Icon sets allow you to…

A

classify data into three to five categories

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

Which of these custom number format codes aligns numbers vertically on the decimal point?

A

????.??

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

Which of the following numbers is represented by 2.60E + 05?

A

260,000.00

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

Which of the following buttons is not available when you click Manage Rules at the Conditional Formatting button drop-down list?

A

Copy Rule

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

In the conditional formatting icon sets gallery, the available icons are organized into four sections. Which of the following is not one of the sections?

A

Alphabetical

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

When applying conditional formatting using predefined rules, the first step is to…

A

select a range of cells

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

How can you tell that a filter has been defined for a column?

A

A filter arrow appears in the column heading

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

How can you format a cell based on the value in a different cell?

A

Use a formula

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

In the Select a Rule Type section of the New Formatting Rule dialog box, you…

A

(?)
NOT specify the cells that will receive the formatting
NOT enter a formula that will be evaluated to determine which type of formatting to apply

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

At the New Formatting Rule dialog box, begin creating a new rule by choosing which of the following?

A

the type of condition for Excel to check before formatting

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

Changing the appearance of a cell based on a condition is called…

A

conditional formatting

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

To filter data using an advanced filter, enter criteria on _____ row(s) when using the And logical operator and enter criteria in _____ row(s).when using the Or logical operator.

A

the same; separate

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

The _____ Excel feature is used to display only the rows that meet specified criteria.

A

Custom AutoFilter

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

Excel provides special number formats that are specific to which of the following?

A

countries and languages

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

Conditional formatting cannot be applied based on which of the following?

A

errors in data entry

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

If a custom number format is deleted, the custom formatting will be removed from which of the following?

A

all the cells to which it was applied in that workbook

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

When filtering a range using an advanced filter, start by…

A

adding five or six rows at the top of the worksheet

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

The Edit the Rule Description section of the New Formatting Rule dialog box varies depending on…

A

the active option in the Select a Rule Type section

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

You can filter values by more than one criterion at a time by using…

A

a comparison operator

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

In the Conditional Formatting Rules Manager dialog box, the default setting for the Show formatting rules for option is…

A

Current Selection

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

If the custom number format code is ###.##, which value will display if the value 23.959 is entered?

A

23.96

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

Which of these questions would best be answered using conditional formatting?

A

Which salespeople exceeded their goals last month?

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

Values in rows that do not meet the criteria in the Custom AutoFilter feature are…

A

temporarily hidden from view

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

Using _____, you can classify data into categories based on threshold values for the selected range.

A

icon sets

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

The first step in creating a custom number format is to…

A

select the range

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

Which of the following is not an example of a conditional formatting rule?

A

Format only values in exponential notation

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

One way to remove conditional formatting is to select the range, click the Conditional Formatting button, point to Clear Rules, and then choose

A

Clear Rules from Selected Cells

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

How do you open the New Formatting Rule dialog box?

A

click New Rule

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

You can edit or delete conditional formatting rules in the _____ dialog box.

A

Conditional Formatting Rules Manager

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

Select the option(s) _____ at the Custom AutoFilter dialog box to specify two criteria by which to filter.

A

And or Or

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

The custom number format allows you to do each of the following except…

A

combine arabic numbers and roman numerals

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

When you delete a custom rule at the Conditional Formatting Rules Manager dialog box, what happens to cells already formatted by the rule?

A

The formatting is removed

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

Which of these custom number format codes will round values to fit the number of digits after the decimal point and fill in leading zeros?

A

000.00

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

Excel can add text such as GX- before all the values typed in cells if the cells have been formatted using the _____ category.

A

Custom

41
Q

You can create custom rules based on each of the following except…

A

cell position

42
Q

As a visual guide to see the variation of values in a range, Excel provides each of the following except…

A

animated graphics

43
Q

Which of the following is not one of the options on the Formatting tab of the Quick Analysis button?

A

Highlight Cell Rules

44
Q

If the appropriate formatting has been applied, data can be filtered by all the following except

A

font type

45
Q

The IF function’s logical test returns _____ result.

A

only a true or false

46
Q

Which of the following is not an option in the Conditional Formatting button drop-down list?

A

Font Sets

47
Q

Exponential notation is often used by engineers and scientists for…

A

very small and very large numbers

48
Q

With conditional formatting, cells that do not meet the criteria specified

A

remain unchanged

49
Q

You _____ create your own conditional formatting rules.

A

can

50
Q

Which of the following is not one of the 13 categories of functions mentioned in Chapter 2?

A

spatial

51
Q

Which of the following represents the proper structure of the arguments for an HLOOKUP function?

A

(lookup_value, table_array, row_index_num, range_lookup)

52
Q

Which of the following scenarios would be the most likely application of the VLOOKUP function?

A

looking up a number grade and returning a letter grade

53
Q

The ABS, RAND, SQRT, and SUMIF functions are in the _____ category.

A

math and trigonometry

54
Q

Which of these functions uses an argument containing multiple criteria?

A

COUNTIFS

55
Q

The VLOOKUP argument that identifies a range of cells, rather than a value, a single cell, or a column number, is…

A

table_array

56
Q

The AND and OR functions use _____ logic to construct a condition test in a formula.

A

Boolean

57
Q

If you divide the interest rate by 12 for a monthly rate with the PMT or PPMT function, you might have to multiply the _____ by 12.

A

number of payment periods

58
Q

A _____ is a preset formula.

A

function

59
Q

What is the first step in creating an AVERAGEIF formula?

A

Make active the cell in which the formula will be inserted

60
Q

You can automatically create range names based on column or row labels by clicking the _____ button in the Defined Names group on the Formulas tab.

A

Create from Selection

61
Q

The lookup_value argument in the VLOOKUP function specifies which of the following?

A

the value that Excel searches for in the reference table

62
Q

Excel’s Lookup & Reference functions provide a way to…

A

look up values in a range

63
Q

Excel stops evaluating an IF formula…

A

once the logical_test has been answered as true

64
Q

In a PPMT function, the argument fv refers to the…

A

balance at the end of the loan

65
Q

Which function should be used if you want to count the number of teams that have won more than 10 games and have fewer than 25 people on the roster?

A

COUNTIFS

66
Q

If a range name used in a formula is deleted, cells that used the name will display this error message.

A

NAME?

67
Q

By default, what happens when the VLOOKUP function does not find an exact match in the first column of the VLOOKUP table?

A

it looks in the first column of the table for the largest value that is less than the lookup_value

68
Q

A function includes two parts: the name of the function and the…

A

argument

69
Q

The _____ function will take the value –7 as an argument and return the value 7.

A

ABS

70
Q

The _____ function will find a value in a column of data and use it in a formula.

A

VLOOKUP

71
Q

The _____ function contains these arguments: (logical_test,value_if_true,value_if_false).

A

IF

72
Q

In a nested IF function, how does Excel help you keep track of the parentheses that belong to each IF function?

A

It color-codes them

73
Q

The _____ argument of the PPMT function can contain only a 1 or a 0.

A

type

74
Q

Which of the following functions will result in a number rounded to the nearest tens value?

A

=ROUND(145,-1)

75
Q

Use the _____ function to find a value when the table contains comparison data organized in rows.

A

HLOOKUP

76
Q

To make a formula easier to read, place each logical test on a new line and then…

A

expand the Formula bar

77
Q

To place an argument or logical test on a new line in the Formula bar, place the insertion point immediately before the logical test and then press which of the following?

A

ALT + enter

78
Q

Use the _____ function with an IF function to test multiple conditions.

A

AND

79
Q

A nested IF formula can be used…

A

when more than two outcomes are possible

80
Q

Excel will add the required syntax automatically when you create a COUNTIF formula…

A

at the Insert Function dialog box

81
Q

MAX and MIN are statistical functions that return the _____ and the _____ value in the range, respectively.

A

largest; smallest

82
Q

The syntax of the COUNTIF and COUNTIFS arguments requires that the criteria _____ if it is not a cell reference.

A

be enclosed in quotation marks

83
Q

The result of an IFS function must test…

A

true

84
Q

The _____ Excel function calculates the principal portion of a loan payment.

A

PPMT

85
Q

What is the keyboard shortcut for opening the Name Manager dialog box?

A

Ctrl + F3

86
Q

The argument (range,criteria,average_range) is required by the _____ function.

A

AVERAGEIF

87
Q

In Excel, an argument can include any of the following except..

A

a specified format

88
Q

The _____ function is in the math and trigonometry function category.

A

SUMIFS

89
Q

Which of the functions discussed in Chapter 2 requires the argument (range1,criteria1,range2,criteria2)?

A

COUNTIFS

90
Q

Unlike a nested IF function, an IFS function does not require each argument to be enclosed in…

A

(?)
NOT parentheses (( ))

91
Q

The COUNTIF function requires two arguments: range and

A

criteria

92
Q

The number of right parentheses needed to end a nested IF statement equals the number of times

A

IF appears in the formula

93
Q

The “range to calculate” argument comes first in all the following functions except the _____ function.

A

SUMIF

94
Q

What argument follows sum_range in the SUMIFS function?

A

criteria_range1

95
Q

Range names can be created, edited, and deleted at the Name Manager dialog box, which is opened by clicking the

A

Name Manager button on the Formulas tab

96
Q

Which of the following formulas uses the correct syntax?

A

=COUNTIF(Expenses,”>700”)

97
Q

In the VLOOKUP function, what does the col_index_num argument indicate?

A

the column number from the lookup table that contains the data to be placed in the formula cell

98
Q

Which of these lookup functions is most commonly used?

A

VLOOKUP

99
Q

Which of the following is not one of the arguments in the PPMT function?

A

pmt

ETM 1030 (18 decks)

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