Question: . Rename the second worksheet as Payment. 2 . Add 3 new columns in this order: Cost of Course, Amount Paid, and Amount Due. Format

. Rename the second worksheet as "Payment".
2. Add 3 new columns in this order: Cost of Course, Amount Paid, and Amount Due. Format the new column headers to match the formatting style of the existing column headers.
3. The cost of this training course is $125. Enter this cost for the first person in the table. Format as currency. Then copy/paste this value in the column for each person.
4. Some employees have fully paid for the course, while others have not. Enter various amounts in the "Amount Paid" column. Format as currency.
5. For the first employee in the "Amount Due" column, enter an Excel formula that calculates any remaining balance. Copy/paste this formula for all employees in the table.
6. Save.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!