Advanced Spreadsheet Techniques Flashcards
1
Q
What function is used to count words?
A
COUNTA
2
Q
What is Relative Reference??
A
Point to a location relative to the location of the formula and is very useful when copying formulas because relative reference updates the formula to it new location
3
Q
What does the PROPER function do?
A
Capitalizes the first letter of each word in a string
4
Q
This function i used to calculate financial info such as interest rate, payment, and loan amortization
A
Financial Function
5
Q
A
