Complete a working Excel spreadsheet based on the following information. Post your Excel spreadsheet in Blackboard.

Title: My Company

Date: Current Date (like February 9, 2020)

Input Area

An input area is the only location that contains numbers. It allows for seeing different output or calculation answers in the Output area.

Input Numbers: (Use in Input Area)

1

1,000

50

25

80

6% or .06

Output Area

An output area should only have formulas (except words that explain what formula represents). Do not type in numbers to this section. The section should only calculate numbers based on formula. In the following information, the ? is the cell location that should contain the calculation formula that reflects the cells used from the input area.

Calculations: (what should show up in the Output Area)

1. Add: 50 + 25 + 1 = ?

2. Divide: 50/25 = ?

3. Subtract: 25 1 = ?

4. Divide: 1,000/your answer for #2 = ?

5. Create a formula for the calculation of interest. Interest = Principal * Rate * Time

1,000 * 6% * 1 = ?

Remember that a working sheet is based on cell locations in the spreadsheet. So, if your numbers are in cells B2 (1), B3 (1000), B4 (50), B5 (25), B6 (80), and B7 (.06) then the ? calculation for number 1 above in Output could be: =B2+B4+B5 this gives the output answer of 76.