BMGT 301 EXAM 1 EXCEL FUNCTIONS UPDATED
ACTUAL QUESTIONS AND CORRECT ANSWERS
Question:
1. TEXT FUNCTIONS
Answer:
Proper, Trim, Upper, Lower
Question:
2. CONCATENATE
Answer:
=CONCATENATE(cell," ", cell," ",cell)
Question:
3. SUMIF
Answer:
range you want the sum of, req for that range
Question:
4. SUMIFS
Answer:
range you want the sum of, criteria range, "req for that range", criteria range, "req
for that range"
Question:
5. AVERAGEIF
Answer:
average of only particular categories
ex // average of all sales made in arizona
=AVERAGE(range you want average of, criteria range, "Req for that range")
Question:
6. AVERAGEIFS
Answer:
ACTUAL QUESTIONS AND CORRECT ANSWERS
Question:
1. TEXT FUNCTIONS
Answer:
Proper, Trim, Upper, Lower
Question:
2. CONCATENATE
Answer:
=CONCATENATE(cell," ", cell," ",cell)
Question:
3. SUMIF
Answer:
range you want the sum of, req for that range
Question:
4. SUMIFS
Answer:
range you want the sum of, criteria range, "req for that range", criteria range, "req
for that range"
Question:
5. AVERAGEIF
Answer:
average of only particular categories
ex // average of all sales made in arizona
=AVERAGE(range you want average of, criteria range, "Req for that range")
Question:
6. AVERAGEIFS
Answer: