Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL1 C2 > Flashcards

EL1 C2 Flashcards

1
Q

When the Trace Error button appears, what is displayed in the upper left corner of the active cell?

A

a small, dark green triangle

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

What type of cell values will the AVERAGE function ignore and not use in its calculation?

A

blank cells

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

When writing a formula by pointing, this displays at the left side of the Status bar.

A

Point

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

To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a…

A

thin black cross

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

What symbol is used to indicate an absolute cell reference?

A

$

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

Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?

A

F4

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

What will happen if you press Ctrl + ` (grave accent)?

A

the worksheet will display formulas instead of results

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

What does the error code #N/A mean?

A

an argument parameter has been left out of a function

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

Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box…?

A

insert function

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

Which of the following is not one of the categories of functions offered by Excel?

A

scientific

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

What does the MIN function return?

A

the minimum function in a range

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

A built-in formula, such as =SUM, is called a(n)…?

A

function

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

The process of calculating a formula and inserting the value in a cell is referred to as…

A

returning the result

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

Which of the following formulas shows an example of a mixed cell reference?

A

=$A$3+B$3

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

Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called…

A

arguments

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

What does the COUNT function count?

A

the number of numeric values in a range

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

Which of the following is not a common mistake made while inputting data in a formula?

A

writing a formula by pointing rather than typing the formula

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

If one of the cells in a range of cells you use as an argument for an AVERAGE function contains text instead of numbers, what will Excel do?

A

ignore the text and calculate the average

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

Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.

A

editing
HOME

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

What does it mean for a formula to have a mixed cell reference?

A

it has a cell reference in which one component (row or column) is relative, while the other is absolute

21
Q

Use this keyboard command to display the Insert Function dialog box.

A

Shift + F3

22
Q

An Insert Function button can be found on the FORMULAS tab and…

A

the formula bar

23
Q

When writing your own formulas, you must begin each formula with…

A

an equals sign =

24
Q

The Trace Error button is a type of…

A

smart tag

25
Q

Excel’s functions are grouped into _____ categories.

A

13

26
Q

Use this function key to update a NOW or TODAY function.

A

F9

27
Q

If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.

A

parentheses

28
Q

How many functions can Excel perform?

A

more than 300

29
Q

Which of the following is not one of the types of cell references discussed in Chapter 2?

A

dynamic

30
Q

If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?

A

the formula will change to =SUM(A3:C3)

31
Q

The function that returns the arithmetic mean of the arguments is called…

A

average

32
Q

The multiple layers of parentheses in a formula are called…

A

nested parentheses

33
Q

What does it mean for a formula to have relative cell references?

A

the cell references change when the formula is copied to a new cell

34
Q

At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.

A

Number1

35
Q

In the Insert Function dialog box, what displays in the Select a function list box?

A

the most recently used functions

36
Q

An absolute cell reference _____ change when copied to another cell.

A

does not

37
Q

If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?

A

MAX

38
Q

When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?

A

a temporary moving border is placed around the cell

39
Q

What happens to formulas with relative cell references when they are copied using the fill handle?

A

a relative version of the formula is copied into the selected cell(s)

40
Q

Use this keyboard command to display formulas in a worksheet.

A

Ctrl + `

41
Q

In Excel’s order of operations, which type of operation happens first?

A

negations

42
Q

This function returns the current date in a date format.

A

=TODAY()

43
Q

In terms of an Excel formula, what is a constant?

A

a value entered directly into a formula

44
Q

Indicate what the following formula will do: =B2/C2.

A

it will divide the contents of cell B2 by the contents of cell C2

45
Q

What error code will display in a cell when a function name is not entered correctly into a formula?

A

NAME?

46
Q

Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.

A

formula auditing
FORMULAS

47
Q

After typing a formula into a cell, you can finish by pressing any of the following keys except…

A

spacebar

48
Q

The Trace Error button allows you to do each of the following except…

A

delete the formula containing the error

49
Q

When writing a formula by pointing, how do you end the formula?

A

press the enter key

ETM 1030 (18 decks)

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