You want to calculate the total amount of sales made by the various categoriesof automobile loans offered by your bank. Which of the following excel formulawould you use in cell B8 shown by the red highlighted box to calculate the totalamount of sales made by various categories of automobile loans?
You want to calculate the total amount of sales made by the various categories of automobile loans offered by your bank. Which of the following excel formula would you use in cell B8 shown by the red highlighted box to calculate the total amount of sales made by various categories of automobile loans?
Aa. =TOTAL(B4:B7)
Bb. =AVG(A4*B4:A7*B7)
Cc. =SIGMA(A4:A7)
Dd. =SUM(B4:B7)
Post your answers here:
Post