Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
NETWORKDAYS
Get the number of working days between two dates start_date end_date (holidays)
26
NETWORKDAYS.INTL
Get work days between two dates start_date end_date (weekend) (holidays)
27
NOW
Get the current date and time
28
SECOND
Get the Second as a number (0-59) from a Time serial_number
29
TIME
Create a time with hours, minutes, and seconds hour minute second
30
TIMEVALUE
Get a valid time from a text string time_text
31
TODAY
Get the current date
32
WEEKDAY
Get the day of the week as a number serial_number (return_type)
33
WEEKNUM
Get the week number for a given date serial_num (return_type)
34
WORKDAY
Get a date n working days in the future or past start_date days (holidays)
35
WORKDAY.INTL
Get date n working days in future or past start_date days (weekend) (holidays)
36
YEAR
Get the year from a date date
37
YEARFRAC
Get the fraction of a year between two dates start_date end_date (basis)
38
BIN2DEC
Converts a binary number to decimal number
39
BIN2HEX
Converts a binary number to hexadecimal number (places)
40
BIN2OCT
Converts a binary number to octal number (places)
41
BITAND
Returns a 'Bitwise And' of two numbers number1 number2
42
BITLSHIFT
Returns a number shifted left by some number of bits number shift_amount
43
BITOR
Returns a 'Bitwise Or' of two numbers number1 number2
44
CONVERT
Convert measurement units number from_unit to_unit
45
DEC2BIN
Converts a decimal number to binary number (places)
46
DEC2HEX
Converts a decimal number to hexadecimal number (places)
47
DEC2OCT
Converts a decimal number to octal number (places)
48
HEX2BIN
Converts a hexadecimal number to binary number (places)
49
HEX2OCT
Converts a hexadecimal number to octal number (places)
50
HEX2DEC
Converts a hexadecimal number to decimal number
51
BITRSHIFT
Returns a number shifted right by some number of bits numbershift_amount
52
BITXOR
Returns a 'Bitwise Xor' of two numbers number1 number2
53
CUMIPMT
Get cumulative interest paid on a loan rate nper pv start_period end_period type
54
CUMPRINC
Get cumulative principal paid on a loan rate nper pv start_period end_period type
55
FV
Get the future value of an investment rate nper pmt (pv) (type)
56
IPMT
Get principal for given period rate per nper pv (fv) (type)
57
IRR
Calculate internal rate of return | values (guess)
58
MIRR
Calculate modified internal rate of return | values finance_rate reinvest_rate
59
NPER
Get number of periods for loan or investment | rate pmt pv (fv) (type)
60
NPV
Calculate net present value rate value1 (value2) (...)
61
PMT
Get the periodic payment for a loan rate nper pv (fv) (type)
62
PPMT
Get principal for given period rate per nper pv (fv) (type)
63
PV
Get the present value of an investment rate nper pmt (fv) (type)
64
RATE
Get the interest rate per period of an annuity nper pmt pv (fv) (type) (guess)
65
XIRR
Calculate internal rate of return for irregular cash flows values dates (guess)
66
XNPV
Calculate net present value for irregular cash flows rate values dates
67
CELL
Get information about a cell info_type (reference)
68
ERROR.TYPE
Test for a specific error value error_val
69
INFO
Get information about current environment type_text
70
ISBLANK
Test if a cell is empty value
71
ISERR
Test for any error but #N/A value
72
ISERROR
Test for any error value
73
ISEVEN
Test if a value is even value
74
ISFORMULA
Test if cell contains a formula reference
75
ISLOGICAL
Test if a value is logical value
76
ISNA
Test for the #N/A error value
77
ISNONTEXT
Test for a non-text value value
78
ISNUMBER
Test for numeric value value
79
ISODD
Test if a value is odd value
80
ISREF
Test for a reference value
81
ISTEXT
Test for a text value value
82
N
Convert a value to a number value
83
NA
Create an #N/A error
84
SHEET
Get sheet index number | value
85
SHEETS
Get number of sheets in a reference | reference
86
TYPE
Get the type of value in a cell value
87
AND
Test multiple conditions with AND logical1 (logical2) (...)
88
FALSE
Generate the logical value FALSE
89
IFERROR
Trap and handle errors value value_if_error
90
IFNA
Trap and handle #N/A errors value value_if_na
91
IF
Test for a specific condition logical_test (value_if_true) (value_if_false)
92
IFS
Test multiple conditions, return first true test1 value1 (test2, value2) (...)
93
NOT
Reverse arguments or results logical
94
OR
Test multiple conditions with OR logical1 (logical2) (...)
95
SWITCH
Match multiple values, return first match expression val1/result1 (val2/result2) (...) (default)
96
TRUE
Generate the logical value TRUE
97
XOR
Perform exclusive OR logical1 (logical2) (...)
98
ADDRESS
``` Create a cell address from a given row and column row_num col_num (abs_num) (a1) (sheet) ```
99
AREAS
Get the number of areas in a reference. reference
100
CHOOSE
Get a value from a list based on position index_num value1 (value2) (...)
101
COLUMN
Get the column number of a reference. | reference
102
COLUMNS
Get the number of columns in an array or reference. | array
103
FORMULA TEXT
Get the formula in a cell reference
104
HLOOKUP
Look up a value in a table by matching on the first row | value table row_index (range_lookup)
105
HYPERLINK
Create a clickable link. | link_location (friendly_name)
106
INDEX
``` Get a value in a list or table based on location array row_num (col_num) (area_num) ```
107
INDIRECT
Create a reference from text | ref_text (a1)
108
LOOKUP
``` Look up a value in a one-column range lookup_value lookup_vector (result_vector) ```
109
MATCH
``` Get the position of an item in an array lookup_value lookup_array (match_type) ```
110
MMULT
Perform matrix multiplication | array1 array2
111
OFFSET
Create a reference offset from given starting point | reference rows cols (height) (width)
112
ROW
Get the row number of a reference | reference
113
ROWS
Get the number of rows in an array or reference. | array
114
TRANSPOSE
Flip the orientation of a range of cells | array
115
VLOOKUP
Lookup a value in a table by matching on the first column | value table col_index (range_lookup)
116
ABS
Find the absolute value of a number number
117
ARABIC
Converts a Roman numerals to an Arabic numerals roman_text
118
ASIN
Get the angle of a triangle. number
119
CEILING
Round a number up to nearest multiple number multiple
120
CEILING.MATH
Round a number up to nearest multiple number (significance) (mode)
121
CEILING.PRECISE
Round a number up to nearest multiple number (significance)
122
COS
Get the cosine of an angle number
123
DECIMAL
Converts an alpha-numeric number to decimal number radix
124
DEGREES
Converts radians to degrees angle
125
EVEN
Round a number up to the next even integer number
126
EXP
Find the value of e raised to the power of a number number
127
FACT
Find the factorial of a number number
128
FLOOR
Round a number down to the nearest specified multiple number multiple
129
FLOOR.MATH
Round number down to nearest multiple number (significance) (mode)
130
FLOOR.PRECISE
Round number down to nearest multiple number (significance)
131
GCD
Get the greatest common divisor of two or more numbers number1 (number2) (...)
132
INT
Get the integer part of a decimal by rounding down number
133
LCM
Get the least common multiple or two or more numbers number1 (number2) (...)
134
LN
Get the natural logarithm of a number number
135
LOG
Get the logarithm of a number number (base)
136
LOG10
Get the base-10 logarithm of a number number
137
MOD
Get the remainder from division number divisor
138
MROUND
Round a number to the nearest specified multiple number multiple
139
POWER
Raise a number to a power number power
140
QUOTIENT
Returns the quotient without a remainder. numerator denominator
141
RADIANS
Converts degrees into radians angle
142
RANDBETWEEN
Get a random integer between two values bottom top
143
ROMAN
Converts numbers to Roman numerals number (form)
144
ROUND
Round a number to a given number of digits number num_digits
145
ROUNDDOWN
Round a number down to a given number of digits number num_digits
146
ROUNDUP
Round a number up to a given number of digits number num_digits
147
SIGN
Get the sign of a number number
148
SIN
Get the sine of an angle number
149
SQRT
Find the positive square root of a number number
150
SUBTOTAL
Get a subtotal in a list or database function_num ref1 (ref2) (...)
151
SUMIF
Sum numbers in a range that meet supplied criteria range criteria (sum_range)
152
SUMIFS
Sum cells that match multiple criteria sum_range range1criteria1 (range2) (criteria2) (...)
153
SUMPRODUCT
Multiply, then sum arrays array1 (array2) (...)
154
TAN
Get the tangent of an angle number
155
TRUNC
Truncate a number to a given precision number (num_digits)

Excel (1 decks)

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