(Solution) 11. Is The Following In A Correct Conventional Income Statement Format? | Snapessays.com


(Solution) 11. Is the following in a correct Conventional Income Statement format?


A. 1. select the set of rows you want to conditionally format to alternate be normal or shaded.   2. Click on the format menu and choose "conditional formatting ."  3. Click plus button to add a new rule  4. change the style to adda new rule  5. change the field to "use a formula to determine which cells to format."6. insert this formula: =mod(row(),20.7. change the "format with" field to "custom format"8. Select a medium shade of gray9. Click OK to close "format Cells window you used to select the gray fill10. Click OK to close the "new formatting rule" window11. click OK to close the "manage rules window"B.     Improve tabular displays by adding "traffic Lights " or other icons in column B (along with the number) to indicate status in terms of "red"= definitely a negative trend, "yellow "=warning , and "green" = definitely a positive trend for sales , sales returns, and the cost of goods sold.        a.  For sales: green means that this years sales are larger than last years ; yellow means that this years sales are at least 98% of the prior years; red otherwise     b. For sales returns; Green means that returns are less than 3.5% of sales; yellow means between 3.5% and 4% of sales ; red means 4% of sales or more  c. For operational expenses , green means less than last year ; yellow means less than a 3% increase; red means more than 3% increase over  the prior year.HINT use the "conditional formatting" toolbar to select :new rule" and then select "icons sets ". You want to change the rule "type" to format so that you can then compare the value in column B to the other columnsYou may want to check the :reverse icon" box for some of the rows where you are placing your icon. 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147601891.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote