Brainscape's Knowledge GenomeTM

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


See full index

Excel > Excel Functions > Flashcards

Excel Functions Flashcards

1
Q

DAVERAGE

A

Get average from matching records

database field criteria

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

DCOUNT

A

Count matching records in a database

database (field) criteria

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

DCOUNTA

A

Count matching records in a database

database (field) criteria

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

DGET

A

Get value from matching record

database field criteria

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

DMAX

A

Get max from matching records

database field criteria

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

DMIN

A

Get min from matching records

database field criteria

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

DPRODUCT

A

Get product from matching records

database field criteria

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

DSTDEV

A

Get standard deviation of sample in matching records

database field criteria

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

DSTDEVP

A

Get standard deviation of population in matching records

database field criteria

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

DSUM

A

Get sum from matching records

database field criteria

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

DVAR

A

Get sample variance for matching records

database field criteria

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

DVARP

A

Get population variance for matching records

database field criteria

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

DATE

A

Create a valid date from year, month, and day

year month day

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

DATEDIF

A

Get days, months, or years between two dates

start_date end_date unit

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

DATEVALUE

A

Convert a date in text format to a valid date

date_text

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

DAY

A

Get the day as a number (1-31) from a date

date

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

DAYS

A

Get days between dates

end_date start_date

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

DAYS360

A

Get days between 2 dates in a 360-day year

start_date end_date (method)

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

EDATE

A

Get the same date in future or past months

start_date months

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

EOMONTH

A

Get the last day of the month in future or past months

start_date months

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

HOUR

A

Get the hour as a number (0-23) from a Time

serial_number

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

ISOWEEK

A

Get ISO week number for a given date

date

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

MINUTE

A

Get the minute as a number (0-59) from a time

serial_number

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

MONTH

A

Get the month as a number (1-12) from a date

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

NETWORKDAYS

A

Get the number of working days between two dates

start_date end_date (holidays)

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

NETWORKDAYS.INTL

A

Get work days between two dates

start_date end_date (weekend) (holidays)

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

NOW

A

Get the current date and time

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

SECOND

A

Get the Second as a number (0-59) from a Time

serial_number

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

TIME

A

Create a time with hours, minutes, and seconds

hour minute second

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

TIMEVALUE

A

Get a valid time from a text string

time_text

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

TODAY

A

Get the current date

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

WEEKDAY

A

Get the day of the week as a number

serial_number (return_type)

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

WEEKNUM

A

Get the week number for a given date

serial_num (return_type)

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

WORKDAY

A

Get a date n working days in the future or past

start_date days (holidays)

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

WORKDAY.INTL

A

Get date n working days in future or past

start_date days (weekend) (holidays)

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

YEAR

A

Get the year from a date

date

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

YEARFRAC

A

Get the fraction of a year between two dates

start_date end_date (basis)

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

BIN2DEC

A

Converts a binary number to decimal

number

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

BIN2HEX

A

Converts a binary number to hexadecimal

number (places)

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

BIN2OCT

A

Converts a binary number to octal

number (places)

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

BITAND

A

Returns a ‘Bitwise And’ of two numbers

number1 number2

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

BITLSHIFT

A

Returns a number shifted left by some number of bits

number shift_amount

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

BITOR

A

Returns a ‘Bitwise Or’ of two numbers

number1 number2

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

CONVERT

A

Convert measurement units

number from_unit to_unit

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

DEC2BIN

A

Converts a decimal number to binary

number (places)

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

DEC2HEX

A

Converts a decimal number to hexadecimal

number (places)

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

DEC2OCT

A

Converts a decimal number to octal

number (places)

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

HEX2BIN

A

Converts a hexadecimal number to binary

number (places)

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

HEX2OCT

A

Converts a hexadecimal number to octal

number (places)

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

HEX2DEC

A

Converts a hexadecimal number to decimal

number

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

BITRSHIFT

A

Returns a number shifted right by some number of bits

numbershift_amount

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

BITXOR

A

Returns a ‘Bitwise Xor’ of two numbers

number1 number2

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

CUMIPMT

A

Get cumulative interest paid on a loan

rate nper pv start_period end_period type

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

CUMPRINC

A

Get cumulative principal paid on a loan

rate nper pv start_period end_period type

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

FV

A

Get the future value of an investment

rate nper pmt (pv) (type)

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

IPMT

A

Get principal for given period

rate per nper pv (fv) (type)

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

IRR

A

Calculate internal rate of return

values (guess)

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

MIRR

A

Calculate modified internal rate of return

values finance_rate reinvest_rate

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

NPER

A

Get number of periods for loan or investment

rate pmt pv (fv) (type)

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

NPV

A

Calculate net present value

rate value1 (value2) (…)

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

PMT

A

Get the periodic payment for a loan

rate nper pv (fv) (type)

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

PPMT

A

Get principal for given period

rate per nper pv (fv) (type)

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

PV

A

Get the present value of an investment

rate nper pmt (fv) (type)

64
Q

RATE

A

Get the interest rate per period of an annuity

nper pmt pv (fv) (type) (guess)

65
Q

XIRR

A

Calculate internal rate of return for irregular cash flows

values dates (guess)

66
Q

XNPV

A

Calculate net present value for irregular cash flows

rate values dates

67
Q

CELL

A

Get information about a cell

info_type (reference)

68
Q

ERROR.TYPE

A

Test for a specific error value

error_val

69
Q

INFO

A

Get information about current environment

type_text

70
Q

ISBLANK

A

Test if a cell is empty

value

71
Q

ISERR

A

Test for any error but #N/A

value

72
Q

ISERROR

A

Test for any error

value

73
Q

ISEVEN

A

Test if a value is even

value

74
Q

ISFORMULA

A

Test if cell contains a formula

reference

75
Q

ISLOGICAL

A

Test if a value is logical

value

76
Q

ISNA

A

Test for the #N/A error

value

77
Q

ISNONTEXT

A

Test for a non-text value

value

78
Q

ISNUMBER

A

Test for numeric value

value

79
Q

ISODD

A

Test if a value is odd

value

80
Q

ISREF

A

Test for a reference

value

81
Q

ISTEXT

A

Test for a text value

value

82
Q

N

A

Convert a value to a number

value

83
Q

NA

A

Create an #N/A error

84
Q

SHEET

A

Get sheet index number

value

85
Q

SHEETS

A

Get number of sheets in a reference

reference

86
Q

TYPE

A

Get the type of value in a cell

value

87
Q

AND

A

Test multiple conditions with AND

logical1 (logical2) (…)

88
Q

FALSE

A

Generate the logical value FALSE

89
Q

IFERROR

A

Trap and handle errors

value value_if_error

90
Q

IFNA

A

Trap and handle #N/A errors

value value_if_na

91
Q

IF

A

Test for a specific condition

logical_test (value_if_true) (value_if_false)

92
Q

IFS

A

Test multiple conditions, return first true

test1 value1 (test2, value2) (…)

93
Q

NOT

A

Reverse arguments or results

logical

94
Q

OR

A

Test multiple conditions with OR

logical1 (logical2) (…)

95
Q

SWITCH

A

Match multiple values, return first match

expression val1/result1 (val2/result2) (…) (default)

96
Q

TRUE

A

Generate the logical value TRUE

97
Q

XOR

A

Perform exclusive OR

logical1 (logical2) (…)

98
Q

ADDRESS

A 
Create a cell address from a given row and column
row_num col_num (abs_num) (a1) (sheet)
99
Q

AREAS

A

Get the number of areas in a reference.

reference

100
Q

CHOOSE

A

Get a value from a list based on position

index_num value1 (value2) (…)

101
Q

COLUMN

A

Get the column number of a reference.

reference

102
Q

COLUMNS

A

Get the number of columns in an array or reference.

array

103
Q

FORMULA TEXT

A

Get the formula in a cell

reference

104
Q

HLOOKUP

A

Look up a value in a table by matching on the first row

value table row_index (range_lookup)

105
Q

HYPERLINK

A

Create a clickable link.

link_location (friendly_name)

106
Q

INDEX

A 
Get a value in a list or table based on location
array row_num (col_num) (area_num)
107
Q

INDIRECT

A

Create a reference from text

ref_text (a1)

108
Q

LOOKUP

A 
Look up a value in a one-column range
lookup_value lookup_vector (result_vector)
109
Q

MATCH

A 
Get the position of an item in an array
lookup_value lookup_array (match_type)
110
Q

MMULT

A

Perform matrix multiplication

array1 array2

111
Q

OFFSET

A

Create a reference offset from given starting point

reference rows cols (height) (width)

112
Q

ROW

A

Get the row number of a reference

reference

113
Q

ROWS

A

Get the number of rows in an array or reference.

array

114
Q

TRANSPOSE

A

Flip the orientation of a range of cells

array

115
Q

VLOOKUP

A

Lookup a value in a table by matching on the first column

value table col_index (range_lookup)

116
Q

ABS

A

Find the absolute value of a number

number

117
Q

ARABIC

A

Converts a Roman numerals to an Arabic numerals

roman_text

118
Q

ASIN

A

Get the angle of a triangle.

number

119
Q

CEILING

A

Round a number up to nearest multiple

number multiple

120
Q

CEILING.MATH

A

Round a number up to nearest multiple

number (significance) (mode)

121
Q

CEILING.PRECISE

A

Round a number up to nearest multiple

number (significance)

122
Q

COS

A

Get the cosine of an angle

number

123
Q

DECIMAL

A

Converts an alpha-numeric number to decimal

number radix

124
Q

DEGREES

A

Converts radians to degrees

angle

125
Q

EVEN

A

Round a number up to the next even integer

number

126
Q

EXP

A

Find the value of e raised to the power of a number

number

127
Q

FACT

A

Find the factorial of a number

number

128
Q

FLOOR

A

Round a number down to the nearest specified multiple

number multiple

129
Q

FLOOR.MATH

A

Round number down to nearest multiple

number (significance) (mode)

130
Q

FLOOR.PRECISE

A

Round number down to nearest multiple

number (significance)

131
Q

GCD

A

Get the greatest common divisor of two or more numbers

number1 (number2) (…)

132
Q

INT

A

Get the integer part of a decimal by rounding down

number

133
Q

LCM

A

Get the least common multiple or two or more numbers

number1 (number2) (…)

134
Q

LN

A

Get the natural logarithm of a number

number

135
Q

LOG

A

Get the logarithm of a number

number (base)

136
Q

LOG10

A

Get the base-10 logarithm of a number

number

137
Q

MOD

A

Get the remainder from division

number divisor

138
Q

MROUND

A

Round a number to the nearest specified multiple

number multiple

139
Q

POWER

A

Raise a number to a power

number power

140
Q

QUOTIENT

A

Returns the quotient without a remainder.

numerator denominator

141
Q

RADIANS

A

Converts degrees into radians

angle

142
Q

RANDBETWEEN

A

Get a random integer between two values

bottom top

143
Q

ROMAN

A

Converts numbers to Roman numerals

number (form)

144
Q

ROUND

A

Round a number to a given number of digits

number num_digits

145
Q

ROUNDDOWN

A

Round a number down to a given number of digits

number num_digits

146
Q

ROUNDUP

A

Round a number up to a given number of digits

number num_digits

147
Q

SIGN

A

Get the sign of a number

number

148
Q

SIN

A

Get the sine of an angle

number

149
Q

SQRT

A

Find the positive square root of a number

number

150
Q

SUBTOTAL

A

Get a subtotal in a list or database

function_num ref1 (ref2) (…)

151
Q

SUMIF

A

Sum numbers in a range that meet supplied criteria

range criteria (sum_range)

152
Q

SUMIFS

A

Sum cells that match multiple criteria

sum_range range1criteria1 (range2) (criteria2) (…)

153
Q

SUMPRODUCT

A

Multiply, then sum arrays

array1 (array2) (…)

154
Q

TAN

A

Get the tangent of an angle

number

155
Q

TRUNC

A

Truncate a number to a given precision

number (num_digits)

Excel (1 decks)

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