Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!
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 OStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started