Excel 5 Flashcards
What does the function CONCATENATE do
Joins two or more text strings
What does the function PROPER do
Capitalizes the first letter of text strings
What is the function that converts all text to uppercase? The one for lowercase?
UPPER uppercase
LOWER lowercase
What does the function SUBSTITUTE do
Replaces text in a text string
What is a delimiter
A separator that should separate your data
What function totals cells in a range meeting a given criteria
SUMIF
What does COUNTIF do
Counts cells Ina range based on a specified condition
What does AVERAGEIF function do
Averages cells In a range based On a specified condition
What is a 3D reference
Referencing other sheets in a workbook
What function simplifies error checking. Hint: users specify message or value for error display
IFERROR
A cell with a circular reference contains a formula that refers to ______
It’s own cell location
What are the three parts to an IF function
- Logical test or condition
- Result if test is true
- Result if test is false
What will the OR function return as if the arguments are true
TRUE
What does the NOT logical function do
Reverses the value of its argument
What does PMT do
Calculates periodic payment amount for money borrowed
