Back to All Flashcards
Card 1 of 12 0%
0Hard
0Learning
0Know It
Question
Loading…
Click to reveal answer
Answer
All 12 Cards
#1
Q: SUM
A: Adds numbers in a range
#2
Q: VLOOKUP
A: Looks up a value in the first column of a table
#3
Q: IF
A: Returns one value if true, another if false
#4
Q: COUNTIF
A: Counts cells that meet a condition
#5
Q: Ctrl + C
A: Copy
#6
Q: Ctrl + Z
A: Undo
#7
Q: Ctrl + Shift + L
A: Toggle filters
#8
Q: AVERAGE
A: Calculates the mean
#9
Q: CONCAT
A: Joins text together
#10
Q: XLOOKUP
A: Modern replacement for VLOOKUP
#11
Q: F4
A: Toggles absolute references
#12
Q: PMT
A: Calculates a loan payment
Explore All 125 Free Decks