Can you please use pictures or do step by step instructions on how to do this. I$\text{'}$m confused and need help. Thank you in advance!

Generate the following six results using pivot tables. Each pivot table should appear on a separate and appropriately named worksheet, like $"$Q$1"$ through $"$Q$6".$ Within each pivot table, the cell$($s$)$ containing the required information should be highlighted, preferably in light orange. In the highlight tab, the theme colors block has $$Orange$,$ Accent $2,$ Lighter $60\%$ you can hover your cursor over colors to see their names. But if you have trouble figuring it out, any non$-$obnoxious light color shade for highlighting is fine.

$1)$ Show the sum of Cost for each Vendor

$2)$ Show the sum of Cost where Product Type $=2$

$3)$ Show the sum of Cost grouped by month $($i$.$e$.,$ a separate total for each month$)$

$4)$ Show the sum of Cost for the three Vendors with the lowest sum of Cost

$5)$ Show the sum of Quantity for the five Vendors with the highest sum of Cost

$6)$ Show the sum of Cost for each Product Type

Below is the data to be copied into excel.

Vendor Product Type Quantity Cost Date

$10013$ $$1701\mathrm{.}9443782$

$54103$ $$1390\mathrm{.}9243741$

$9752$ $$1605\mathrm{.}5443666$

$2754$ $$1645\mathrm{.}1743773$

$591$ $$1909\mathrm{.}2143721$

$90104$ $$399\mathrm{.}4143744$

$1054$ $$1685\mathrm{.}5743688$

$6583$ $$957\mathrm{.}2043792$

$3173$ $$1835\mathrm{.}0743690$

$41124$ $$351\mathrm{.}2743713$

$2733$ $$1230\mathrm{.}8743670$

$92102$ $$547\mathrm{.}7443706$

$88123$ $$284\mathrm{.}5543624$

$2234$ $$1325\mathrm{.}3543626$

$6094$ $$407\mathrm{.}7643743$

$6735$ $$1144\mathrm{.}5143640$

$1824$ $$924\mathrm{.}1243727$

$7935$ $$1415\mathrm{.}0243717$

$6342$ $$254\mathrm{.}5643666$

$981$ $$679\mathrm{.}3843679$

$80113$ $$1209\mathrm{.}7743681$

$2815$ $$1182\mathrm{.}9643712$

$6374$ $$1611\mathrm{.}3743760$

$1583$ $$601\mathrm{.}2043778$

$2843$ $$839\mathrm{.}3743623$

$7544$ $$1288\mathrm{.}8643660$

$4832$ $$1211\mathrm{.}2743701$

$4832$ $$836\mathrm{.}2743724$

$4581$ $$36\mathrm{.}4843646$

$2654$ $$1870\mathrm{.}5443618$

$7144$ $$1885\mathrm{.}6543796$

$9862$ $$1757\mathrm{.}6943739$

$6023$ $$412\mathrm{.}1943797$

$2284$ $$1703\mathrm{.}1743641$

$60104$ $$1246\mathrm{.}7843691$

$6131$ $$404\mathrm{.}1143710$

$33113$ $$1158\mathrm{.}6043755$

$7321$ $$1492\mathrm{.}0043655$

$9692$ $$485\mathrm{.}2643646$

$9862$ $$671\mathrm{.}5443757$

$1592$ $$251\mathrm{.}3443679$

$27112$ $$562\mathrm{.}6843682$

$5164$ $$564\mathrm{.}0743696$

$9045$ $$1996\mathrm{.}9643732$

$5764$ $$111\mathrm{.}0843690$

$1834$ $$186\mathrm{.}6443675$

$55122$ $$739\mathrm{.}1443636$

$21124$ $$651\mathrm{.}2143611$

$1352$ $$1970\mathrm{.}7243606$

$5251$ $$1900\mathrm{.}3743606$

$5085$ $$1252\mathrm{.}7943650$

$90113$ $$1596\mathrm{.}7343749$

$20112$ $$270\mathrm{.}4443681$

$4285$ $$1531\mathrm{.}5743753$

$9992$ $$1150\mathrm{.}2843773$

$2584$ $$488\mathrm{.}5043779$

$4352$ $$788\mathrm{.}2843620$

$5535$ $$629\mathrm{.}3343712$

$9533$ $$679\mathrm{.}8643698$

$7611$ $$120\mathrm{.}2643636$

$3664$ $$1796\mathrm{.}5543644$

$2454$ $$445\mathrm{.}4543754$

$2131$ $$916\mathrm{.}6143699$

$82103$ $$1777\mathrm{.}9843683$

$4544$ $$799\mathrm{.}0543651$

$8313$ $$451\mathrm{.}0143602$

$3982$ $$1690\mathrm{.}6343673$

$5374$ $$1245\mathrm{.}7543733$

$352$ $