Functions

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/74

encourage image

There's no tags or description

Looks like no tags are added yet.

75 Terms

1
New cards

HLOOKUP

Performs a horizontal lookup by searching for a value in the top row of a table and returning the value in the same column based on the index_number.

2
New cards

INDEX

Returns either the value or the reference to a value from a table or range.

3
New cards

TRANSPOSE

Returns a transposed range of cells.

4
New cards

VLOOKUP

Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

5
New cards

XLOOKUP

Performs a lookup (either vertical or horizontal).

6
New cards

CONCAT

Used to join 2 or more strings together.

7
New cards

FIND

Returns the location of a substring in a string (case-sensitive).

8
New cards

LEFT

Extracts a substring from a string, starting from the left-most character.

9
New cards

LEN

Returns the length of the specified string.

10
New cards

LOWER

Converts all letters in the specified string to lowercase.

11
New cards

MID

Extracts a substring from a string (starting at any position).

12
New cards

NUMBERVALUE

Returns a text to a number specifying the decimal and group separators.

13
New cards

PROPER

Sets the first character in each word to uppercase and the rest to lowercase.

14
New cards

REPLACE

Replaces a sequence of characters in a string with another set of characters.

15
New cards

RIGHT

Extracts a substring from a string starting from the right-most character.

16
New cards

SEARCH

Returns the location of a substring in a string.

17
New cards

TRIM

Returns a text value with the leading and trailing spaces removed.

18
New cards

UPPER

Converts text to all uppercase.

19
New cards

VALUE

Converts a text value that represents a number to a number.

20
New cards

DATE

Returns the serial date value for a date.

21
New cards

DATEDIF

Returns the difference between two date values, based on the interval specified.

22
New cards

DAY

Returns the day of the month (a number from 1 to 31) given a date value.

23
New cards

DAYS

Returns the number of days between 2 dates.

24
New cards

HOUR

Returns the hours (a number from 0 to 23) from a time value.

25
New cards

MINUTE

Returns the minutes (a number from 0 to 59) from a time value.

26
New cards

MONTH

Returns the month (a number from 1 to 12) given a date value.

27
New cards

NOW

Returns the current system date and time.

28
New cards

SECOND

Returns the seconds (a number from 0 to 59) from a time value.

29
New cards

TIME

Returns a decimal number given an hour, minute and second value.

30
New cards

TODAY

Returns the current system date.

31
New cards

WEEKDAY

Returns a number representing the day of the week, given a date value.

32
New cards

WEEKNUM

Returns the week number for a date.

33
New cards

YEAR

Returns a four-digit year (a number from 1900 to 9999) given a date value.

34
New cards

CEILING

Returns a number rounded up based on a multiple of significance.

35
New cards

FLOOR

Returns a number rounded down based on a multiple of significance.

36
New cards

INT

Returns the integer portion of a number.

37
New cards

RAND

Returns a random number that is greater than or equal to 0 and less than 1.

38
New cards

RANDBETWEEN

Returns a random number that is between a bottom and top range.

39
New cards

ROUND

Returns a number rounded to a specified number of digits.

40
New cards

ROUNDDOWN

Returns a number rounded down to a specified number of digits.

41
New cards

ROUNDUP

Returns a number rounded up to a specified number of digits.

42
New cards

SIGN

Returns the sign of a number.

43
New cards

SUBTOTAL

Returns the subtotal of the numbers in a column in a list or database.

44
New cards

SUM

Adds all numbers in a range of cells.

45
New cards

SUMIF

Adds all numbers in a range of cells based on one criteria.

46
New cards

SUMIFS

Adds all numbers in a range of cells, based on a single or multiple criteria.

47
New cards

AVERAGE

Returns the average of the numbers provided.

48
New cards

AVERAGEIF

Returns the average of all numbers in a range of cells, based on a given criteria.

49
New cards

AVERAGEIFS

Returns the average of all numbers in a range of cells, based on multiple criteria.

50
New cards

COUNT

Counts the number of cells that contain numbers as well as the number of arguments that contain numbers.

51
New cards

COUNTBLANK

Counts the number of empty cells in a range.

52
New cards

COUNTIF

Counts the number of cells in a range that meets a given criteria.

53
New cards

COUNTIFS

Counts the number of cells in a range that meets a single or multiple criteria.

54
New cards

MEDIAN

Returns the median of the numbers provided.

55
New cards

MIN

Returns the smallest value from the numbers provided.

56
New cards

RANK

Returns the rank of a number within a set of numbers.

57
New cards

STDEV

Returns the standard deviation of a population based on a sample of numbers.

58
New cards

AND

Returns TRUE if all conditions are TRUE.

59
New cards

IF

Returns one value if the condition is TRUE or another value if the condition is FALSE.

60
New cards

IFERROR

Used to return an alternate value if a formula results in an error.

61
New cards

IFNA

Used to return an alternate value if a formula results in #N/A error.

62
New cards

IFS

Specifies multiple IF conditions within 1 function.

63
New cards

NOT

Returns the reversed logical value.

64
New cards

OR

Returns TRUE if any of the conditions are TRUE.

65
New cards

ISBLANK

Used to check for blank or null values.

66
New cards

ISNA

Used to check for #N/A error.

67
New cards

ISNUMBER

Used to check for a numeric value.

68
New cards

FV

Returns the future value of an investment.

69
New cards

IPMT

Returns the interest payment for an investment.

70
New cards

ISPMT

Returns the interest payment for an investment.

71
New cards

NPER

Returns the number of periods for an investment.

72
New cards

NPV

Returns the net present value of an investment.

73
New cards

PMT

Returns the payment amount for a loan.

74
New cards

PV

Returns the present value of an investment.

75
New cards

RATE

Returns the interest rate for an annuity.