Question: Please help, i am using office 360. Please show all the steps and formulas. Thank you! A B D E F G H 1 2

Please help, i am using office 360. Please show all the steps and formulas. Thank you!

Please help, i am using office 360. Please show all the steps

A B D E F G H 1 2 3 Summary Total Debits Total Credits Diff 4 5 $25,853.00 $25,853.00 $0.00 6 7 8 Telephone Expense Allocation 9 10 Credit 11 12 13 14 15 16 17 18 19 20 21 22 23 Account Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Department Comments Operations To allocate telco by cell number Research To allocate telco by cell number Manufacturing To allocate telco by cell number Sales To allocate telco by cell number Marketing To allocate telco by cell number Logistics To allocate telco by cell number IT To allocate telco by cell number Warehouse To allocate telco by cell number Accounting To allocate telco by cell number Corporate To allocate telco by cell number Debit $3,750.82 $2,120.97 $1,297.83 $12,725.13 $1,982.20 $125.25 $2,207.85 $497.20 $1,145.75 $25,853.00 Required: 1. Format the Diff value with Green Fill with Dark Green Text if the value equals 0. 2. Format the Diff value with Light Red Fill with Dark Red Text if the value does not equal O. A B D E F G H 1 2 3 Summary Total Debits Total Credits Diff 4 5 $25,853.00 $25,853.00 $0.00 6 7 8 Telephone Expense Allocation 9 10 Credit 11 12 13 14 15 16 17 18 19 20 21 22 23 Account Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Telephone Department Comments Operations To allocate telco by cell number Research To allocate telco by cell number Manufacturing To allocate telco by cell number Sales To allocate telco by cell number Marketing To allocate telco by cell number Logistics To allocate telco by cell number IT To allocate telco by cell number Warehouse To allocate telco by cell number Accounting To allocate telco by cell number Corporate To allocate telco by cell number Debit $3,750.82 $2,120.97 $1,297.83 $12,725.13 $1,982.20 $125.25 $2,207.85 $497.20 $1,145.75 $25,853.00 Required: 1. Format the Diff value with Green Fill with Dark Green Text if the value equals 0. 2. Format the Diff value with Light Red Fill with Dark Red Text if the value does not equal O

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 Accounting Questions!