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.
This question was answered on: May 23, 2022
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)
May 23, 2022EXPERT
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: