BMGT 301 TEST BANK UPDATED
QUESTIONS AND VERIFIED ANSWERS
EXAM SUCCESS GUIDE
●● CONCATENATE
Answer: =CONCATENATE(cell," ", cell," ",cell)
●● SUMIF
Answer: range you want the sum of, req for that range
●● SUMIFS
Answer: range you want the sum of, criteria range, "req for that range",
criteria range, "req for that range"
●● 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")
●● AVERAGEIFS
Answer:
QUESTIONS AND VERIFIED ANSWERS
EXAM SUCCESS GUIDE
●● CONCATENATE
Answer: =CONCATENATE(cell," ", cell," ",cell)
●● SUMIF
Answer: range you want the sum of, req for that range
●● SUMIFS
Answer: range you want the sum of, criteria range, "req for that range",
criteria range, "req for that range"
●● 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")
●● AVERAGEIFS
Answer:
