Brainscape's Knowledge GenomeTM

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


See full index

Bus 311 > Quiz 1 > Flashcards

Quiz 1 Flashcards

1
Q

When copying a cell, the term absolute cell reference indicates

A

cell reference will not change

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

The median function is used to find

A

middle number in the range of cells

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

If you wanted to determine how many cells in a range are not empty, you would use the

A

COUNTA function

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

=D5 is an example of an absolute cell value

A

False

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

$R$5 is an example of mixed cell reference

A

False

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

To tally a column you use the COUNT function

A

True

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

The today and Now functions return the same results

A

False

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

Average and Median are two functions used to determine central tendencies

A

True

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

The IF function is an example of a logical function

A

True

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

The PMT calculates the amount of mortgage

A

False

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

Range names are edited and deleted using the name manager

A

True

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

When cell C3 containing the formula =B6*C8 is copied to cell D2, the formula in cell D2 is

A

C5*D7

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

The name for a range can begin with a letter or

A

underscore

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

=D$3 is an example of a(n)

A

Mixed cell reference

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

Which Excel function displays the current date?

A

Today

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

The expression that implements the flow chart shown in the above figure is

A

IF(E2>B$2,B$3,0)

17
Q

A range name can contain up to

A

255 characters`

18
Q

A formula that refers to its own cell creates a(n)

A

circular reference

19
Q

chart shows the proportion of individual parts to the whole.

A

A pie

20
Q

Which of the following is NOT a chart element?

A

Data Series

21
Q

is a small line or column that is displayed in a single cell.

A

Sparkline

22
Q

By default, axes are displayed when a chart is created.

A

True

23
Q

are used to show the exact value or the name of data points

A

Labels

24
Q

determines which data series and categories are displayed in a chart.

A

A chart filter

25
Q

Once a chart has been created, you can change its type.

A

true

26
Q

By default, axis titles are displayed when a chart is created.

A

False

Bus 311 (4 decks)

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