Topic 1: More about Formulas and Functions (graded):

Based on your work in this unit and the Atomic Learning Tutorials and readings, address the following scenario.

Mr. Johnson, a recent hire for the Abacas Accounting firm, was tasked with updating an existing Excel spreadsheet by adding the bonuses to the employees who had sales of $500 and more for the first quarter. Proper formatting was required on each Excel spreadsheet (e.g., date, font, color, column height, and column width).

Discuss the various formulas, functions, and formatting Mr. Johnson could use to accomplish his task.