AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.
A) use the Sum built-in function
B) use the Average built-in function
C) create a new function called CalcAvg
D) use another programming language

Question

Quizplus · Accepted Answer

The best option is to use the Average built-in function in VBA to calculate the average salaries for the past five years. This function will add up all the salaries and divide by the number of salaries to get the average. It is a simpler and more efficient option than creating a new function or using a different programming language.

AC Adv Case 13-1 Eric Has Been Asked to Write