Excel Formulas

Question 1

Function

Answer 1

Formula

Question 2

INDEX

Answer 2

=INDEX(array, row_num, [col_num])

Question 3

MATCH

Answer 3

=MATCH(lookup_value, lookup_array, [match_type])

Question 4

VLOOKUP

Answer 4

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

Question 5

HLOOKUP

Answer 5

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Question 6

XLOOKUP

Answer 6

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Question 7

OFFSET

Answer 7

=OFFSET(reference, rows, cols, [height], [width])

Question 8

IF

Answer 8

=IF(logical_test, value_if_true, value_if_false)

Question 9

IFERROR

Answer 9

=IFERROR(value, value_if_error)

Question 10

CHOOSE

Answer 10

=CHOOSE(index_num, value1, value2, …)

Question 11

TEXT

Answer 11

=TEXT(value, format_text)

Question 12

ROUND

Answer 12

=ROUND(number, num_digits)

Question 13

ROUNDUP

Answer 13

=ROUNDUP(number, num_digits)

Question 14

ROUNDDOWN

Answer 14

=ROUNDDOWN(number, num_digits)

Question 15

NPV

Answer 15

=NPV(rate, value1, [value2], …)

Question 16

IRR

Answer 16

=IRR(values, [guess])

Question 17

XIRR

Answer 17

=XIRR(values, dates, [guess])

Question 18

PV

Answer 18

=PV(rate, nper, pmt, [fv], [type])

Question 19

FV

Answer 19

=FV(rate, nper, pmt, [pv], [type])

Question 20

PMT

Answer 20

=PMT(rate, nper, pv, [fv], [type])

Question 21

EOMONTH

Answer 21

=EOMONTH(start_date, months)

Question 22

EDATE

Answer 22

=EDATE(start_date, months)

Question 23

YEARFRAC

Answer 23

=YEARFRAC(start_date, end_date, [basis])

Question 24

DAYS

Answer 24

=DAYS(end_date, start_date)

Question 25

TODAY

Answer 25

=TODAY()

Question 26

NOW

Answer 26

=NOW()

Question 27

LEN

Answer 27

=LEN(text)

Question 28

LEFT

Answer 28

=LEFT(text, num_chars)

Question 29

RIGHT

Answer 29

=RIGHT(text, num_chars)

Question 30

MID

Answer 30

=MID(text, start_num, num_chars)