Please help, i am using office 360. Thank you!
Table-1
1)
DeptID | Department | Actaul | Forecast | Variance |
100 | Coporate | $187,274 | $175,000 | -7.01% |
101 | Accounting | $61,456 | $60,000 | -2.43% |
102 | HR | $88,133 | $90,000 | 2.07% |
200 | Operations | $167,209 | $150,000 | -11.47% |
202 | Research | $116,801 | $125,000 | 6.56% |
206 | Manufacturing | $175,202 | $165,000 | -6.18% |
301 | Sales | $169,975 | $125,000 | -35.98% |
305 | Marketing | $212,012 | $185,000 | -14.60% |
400 | Logistics | $172,371 | $200,000 | 13.81% |
410 | IT | $92,749 | $100,000 | 7.25% |
420 | Warehouse | $57,845 | $75,000 | 22.87% |
2)
DeptID | Department | Actaul | Forecast | Variance |
100 | Coporate | $187,274 | $175,000 | -7.01% |
101 | Accounting | $61,456 | $60,000 | -2.43% |
102 | HR | $88,133 | $90,000 | 2.07% |
200 | Operations | $167,209 | $150,000 | -11.47% |
202 | Research | $116,801 | $125,000 | 6.56% |
206 | Manufacturing | $175,202 | $165,000 | -6.18% |
301 | Sales | $169,975 | $125,000 | -35.98% |
305 | Marketing | $212,012 | $185,000 | -14.60% |
400 | Logistics | $172,371 | $200,000 | 13.81% |
410 | IT | $92,749 | $100,000 | 7.25% |
420 | Warehouse | $57,845 | $75,000 | 22.87% |
Table-2
1)
Summary | ||
Total Debits | $25,853 | |
Total Credits | $25,853 | |
$0.00 |
2) Difference Value is equal to $0.00, so no color will apply even using formula and will be seen as plain table as per following:
Summary | ||
Total Debits | $25,853 | |
Total Credits | $25,853 | |
$0.00 |
Please show all the steps. I am using office 360. Thank you! A B C D E F G H 1 1 2 Inventory Turnover 3 5 4 5 6 7 8 9 10 11 12 13 14 15 16 Item AB101 XY200 CG231 HA882 ZZ750 LLOO2 PY552 JJ120 JA221 RJ061 Turnover 12.5 20.1 8.2 1.1 2.1 3.6 10.9 18.2 11.7 5.2 Required: Apply the 5 Quarters Icon Sets formatting to the Turnover column. 17 B17 A В с D...