Level 1 Exam Question 5


I did all the formulas correct for Bonus, Car, Medical but when it ask me total for Sales department for December 2020 and I entered XXXXXX for phone cost. It gives me incorrect answer. No sure were I went wrong. How do I trace back?





  • One thing I noticed at right top corner it is displaying actual figure and in the cell it is displaying rounded figure. Is that the issue?

  • @abhishah 

    You don't need to multiply the expenses by the salary. Only bonus.

    As a courtesy though, try not to post exam answers on the forum. We want to make sure we provide guidance but not direct answers.

    You got this!

  • I will keep that in mind for next post. Sorry didn't mean to expose the answer. Thanks for your prompt response. Let me check and will let you know.