Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Thomas Edmonds, Christopher, Philip Olds, Frances McNair, Bor

4th edition

77862376, 978-0077862374

More Books

Students also viewed these Accounting questions

Question

Explain the usefulness of conflict analysis

Answered: 1 week ago

Question

=+20.19. Let A ,., () = [IZ, - Z|

Answered: 1 week ago