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".
Add 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.
The cost of this training course is $ Enter this cost for the first person in the table. Format as currency. Then copypaste this value in the column for each person.
Some employees have fully paid for the course, while others have not. Enter various amounts in the "Amount Paid" column. Format as currency.
For the first employee in the "Amount Due" column, enter an Excel formula that calculates any remaining balance. Copypaste this formula for all employees in the table.
Save.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
