week 7 excel Flashcards
1
Q
AVERAGE
A
Calculate the average of a list of numbers
2
Q
CONCAT
A
put data side by side
3
Q
COUNT
A
count how many cells have number data
4
Q
COUNTA
A
count how many cells have text data
5
Q
COUNTBLANK
A
count how many blank cells there are
6
Q
IF
A
get computer to decide between 2 outcomes
7
Q
LEFT
A
prints the first letter, the leftmost letter
8
Q
LOWER
A
print all data in small letters (lowercase)
9
Q
MAX
A
identify the largest number in a list - the maximum number
10
Q
MIN
A
identify the smallest number in a list - the minimum number
11
Q
NOW
A
print the current date and time
12
Q
PMT (payment)
A
calculate the monthly payment on a bank loan
13
Q
PROPER
A
print the 1st letter of each word in capital letters
14
Q
RIGHT
A
prints the last letter, the rightmost letter
15
Q
SUM
A
add a list of numbers
