Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

MIS > Exam 2 > Flashcards

Exam 2 Flashcards

1
Q

Pane splitting/Freezing

A

Layout>Window

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

Data Sorting

A

Data> Sort & Filter

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

SUM Function

A

Adds all the arguments in a range

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

absolute reference

A

f4

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

goal seek

A

Data>What if>Goal Seek

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

Conditional Formatting

A

Home>Format

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

Protecting a Worksheet

A

right click on the worksheet tab>protect sheet

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

SUMIF

A

sum cells based on certain criteria

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

FV function

A

calculates the future value of an investment based on a constant interest rate.
=FV(rate,nper,pmt,[pv],[type])

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

PV function

A

calculates the present value of a loan or an investment, based on a constant interest rate.
=PV(rate, nper, pmt, [fv], [type])

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

PMT function

A

calculates the payment for a loan based on constant payments and a constant interest rate. =PMT(rate, nper, pv, [fv], [type])

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

IPMT function

A

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
=IPMT(rate, per, nper, pv, [fv], [type])

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

PPMT function

A

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
=PPMT(rate, per, nper, pv, [fv], [type])

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

SLN function

A

Returns the straight-line depreciation of an asset for one period.
=SLN(cost, salvage, life)

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

SYD function

A

Returns the sum-of-years’ digits depreciation of an asset for a specified period.
=SYD(cost, salvage, life, per)

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

DDB function

A

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
=DDB(cost, salvage, life, period, [factor])

17
Q

NPER function

A

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. =NPER(rate,pmt,pv,[fv],[type])

18
Q

RATE function

A

Returns the interest rate per period of an annuity.

=RATE(nper, pmt, pv, [fv], [type], [guess])

19
Q

IRR function

A

Returns the internal rate of return for a series of cash flows represented by the numbers in values.
=IRR(values, [guess])

20
Q

CUMIPMT function

A

Returns the cumulative interest paid on a loan between start_period and end_period.
=CUMIPMT(rate, nper, pv, start_period, end_period, type)

21
Q

CUMPRINC function

A

Returns the cumulative principal paid on a loan between start_period and end_period.
=CUMPRINC(rate, nper, pv, start_period, end_period, type)

22
Q

XNPV function

A

Returns the net present value for a schedule of cash flows that is not necessarily periodic. =XNPV(rate, values, dates)

23
Q

XIRR function

A

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
=XIRR(values, dates, [guess])

24
Q

IF function

A

returns one value if a condition is true and another value if it’s false.
=IF(logical_test, value_if_true, [value_if_false])

25
Q

AND function

A

Returns TRUE if all is arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
=AND(logical1, [logical2], …)

26
Q

OR function

A

returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
=OR(logical1, [logical2], …)

27
Q

NESTED IF function

A

multiple IF functions inside each other.

28
Q

VLOOKUP function

A

when you need to find things in a table or a range by row.

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

29
Q

HLOOKUP function

A

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

30
Q

TRANSPOSE function

A

The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa.
=TRANSPOSE(array)

31
Q

COUNTIF function

A

to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
=COUNTIF(range, criteria)

32
Q

AVERAGEIF function

A

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
=AVERAGEIF(range, criteria, [average_range])

33
Q

MONTH function

A

Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
=MONTH(serial_number)

34
Q

Category Axis

A

Horizontal or X axis

35
Q

Value axis

A

Vertical or Y axis

36
Q

Sparklines

A

a tiny chart in the background of a cell

37
Q

Data Bars

A

under conditional formatting

MIS (1 decks)

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