Question: help solve 1.6 on excel step by step ormatting to highlight the bottom 15% of values for minutes of stream time. a. Apply the conditional

help solve 1.6 on excel step by step

ormatting to highlight the bottom 15% of values for minutes of stream time. a. Apply the conditional formatting to range on the Top worksheet. b. Higlight the bottom 15% of values for stream time with light red background and dark red text. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Channel & Watch Time & Stream Time & Peak Viewers & Average Viewers & followers & Language \\ \hline & 744620970 & 118125 & 26141 & 6328 & 859439E & English \\ \hline AdmiralBahroo & 1188645990 & 141210 & 21053 & 8152 & 778055E & Engilsh \\ \hline Admiralibulidog & 972317520 & 154845 & 16681 & 6198 & 694253F & English \\ \hline & 779867430 & 169515 & 23555 & 4642 & 414951C & Crech \\ \hline & 2055003870 & 103770 & 89153 & 19560 & 3445134 & Portuguese \\ \hline allkershop_tr 2x & 667185955 & 487005 & 6075 & 1361 & Gran & English \\ \hline Arnouranth & 618067800 & 235170 & 13495 & 2560 & 1707804E & English \\ \hline Anomaly & 2565429915 & 92880 & 125408 & 12377 & 2607076 & English \\ \hline & 581034300 & 142890 & 137531 & 3199 & 207981E & English \\ \hline Asmongold & 3668799075 & 82260 & 263720 & 42414 & 1563438E & English \\ \hline & 2410022550 & 40575 & 170115 & 53986 & 3983847 s & Spanish \\ \hline Baiano =0 & 859718520 & 85860 & 107069: & 9229 & 425797 & Portuguese \\ \hline benjyfistiy & 580787955 & 34350 & 75491 & 14423 & 1739112 & English \\ \hline BeyondTheSummit & 1339097490 & 505080 & 116547 & 2635 & 923689 & English \\ \hline BLASTPremier & 753808200 & 25260 & 113167 & 24689 & 501371 & English \\ \hline blusewrilly_retry & 618755280 & 100515 & 17585 & 5941 & 374480 & Chinese \\ \hline & 558170835 & 233035 & 11659 & 2175 & 1519266E & English \\ \hline bratishkinoff & 646333065 & 60795 & 56790 & 10626 & 1128907 & Russian \\ \hline & $59915035 & 183225 & 64308 & 2844 & 659652 & Spanish \\ \hline Bughtia: & 1324519320 & 100470 & 66311 & 12982 & 2942212 & English \\ \hline buster & 884353800 & 59295 & 97838 & 14195 & 108737 & Russian \\ \hline cike: & 586662010 & 129660 & 17317 & 4403 & 302633 & Russian \\ \hline CasinoDaddy & 577240710 & 267465 & 6524 & 2168 & 151098 & English \\ \hline Castro 1021 & 1845157080 & 100215 & 125133 & 17779 & 2411995 & English \\ \hline CDNThe3rd & 722562675 & 134280 & 55752 & 4919 & 2009972 & English \\ \hline Cellbit & 817373955 & 103095 & 68813 & 8264 & 1293451 & 1 Portuguese \\ \hline Chap & 550951215 & 157545 & 22571 & 3430 & 1272899 & English \\ \hline chocotaco & 620395515 & 160830 & 30514 & 3846 & 1134153 & English \\ \hline & 558883590 & 273660 & 33624 & 1941 & 105623 & English \\ \hline & 1256647110 & 89760 & 81926 & 12996 & 2035180 & English \\ \hline \end{tabular} ormatting to highlight the bottom 15% of values for minutes of stream time. a. Apply the conditional formatting to range on the Top worksheet. b. Higlight the bottom 15% of values for stream time with light red background and dark red text. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Channel & Watch Time & Stream Time & Peak Viewers & Average Viewers & followers & Language \\ \hline & 744620970 & 118125 & 26141 & 6328 & 859439E & English \\ \hline AdmiralBahroo & 1188645990 & 141210 & 21053 & 8152 & 778055E & Engilsh \\ \hline Admiralibulidog & 972317520 & 154845 & 16681 & 6198 & 694253F & English \\ \hline & 779867430 & 169515 & 23555 & 4642 & 414951C & Crech \\ \hline & 2055003870 & 103770 & 89153 & 19560 & 3445134 & Portuguese \\ \hline allkershop_tr 2x & 667185955 & 487005 & 6075 & 1361 & Gran & English \\ \hline Arnouranth & 618067800 & 235170 & 13495 & 2560 & 1707804E & English \\ \hline Anomaly & 2565429915 & 92880 & 125408 & 12377 & 2607076 & English \\ \hline & 581034300 & 142890 & 137531 & 3199 & 207981E & English \\ \hline Asmongold & 3668799075 & 82260 & 263720 & 42414 & 1563438E & English \\ \hline & 2410022550 & 40575 & 170115 & 53986 & 3983847 s & Spanish \\ \hline Baiano =0 & 859718520 & 85860 & 107069: & 9229 & 425797 & Portuguese \\ \hline benjyfistiy & 580787955 & 34350 & 75491 & 14423 & 1739112 & English \\ \hline BeyondTheSummit & 1339097490 & 505080 & 116547 & 2635 & 923689 & English \\ \hline BLASTPremier & 753808200 & 25260 & 113167 & 24689 & 501371 & English \\ \hline blusewrilly_retry & 618755280 & 100515 & 17585 & 5941 & 374480 & Chinese \\ \hline & 558170835 & 233035 & 11659 & 2175 & 1519266E & English \\ \hline bratishkinoff & 646333065 & 60795 & 56790 & 10626 & 1128907 & Russian \\ \hline & $59915035 & 183225 & 64308 & 2844 & 659652 & Spanish \\ \hline Bughtia: & 1324519320 & 100470 & 66311 & 12982 & 2942212 & English \\ \hline buster & 884353800 & 59295 & 97838 & 14195 & 108737 & Russian \\ \hline cike: & 586662010 & 129660 & 17317 & 4403 & 302633 & Russian \\ \hline CasinoDaddy & 577240710 & 267465 & 6524 & 2168 & 151098 & English \\ \hline Castro 1021 & 1845157080 & 100215 & 125133 & 17779 & 2411995 & English \\ \hline CDNThe3rd & 722562675 & 134280 & 55752 & 4919 & 2009972 & English \\ \hline Cellbit & 817373955 & 103095 & 68813 & 8264 & 1293451 & 1 Portuguese \\ \hline Chap & 550951215 & 157545 & 22571 & 3430 & 1272899 & English \\ \hline chocotaco & 620395515 & 160830 & 30514 & 3846 & 1134153 & English \\ \hline & 558883590 & 273660 & 33624 & 1941 & 105623 & English \\ \hline & 1256647110 & 89760 & 81926 & 12996 & 2035180 & English \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

how am i supposed to do the right formulas. #3 letter d especially Safari File Edit View History Bookmarks Window Help Instructions... Destan Layout Reference Com A. Font Paragraph Styles Dictate...

Exp19_Excel_AppCapstone_Intro Assessment_Travel Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston....

Excel Assignment Need Video instructions on how to complete the steps AutoSave On Av Co... 2 Exp19_Excel_AppCapstone_CompAssessment_Manufacturing_Instructions - Saved to my Mac References Mailings...

Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report...

what isnt visible? Ginadsr - Instructicns Exp19_Excel_AppCapstone_IntroAssessment_Travel Project Deecriptlon: You are consibaring scyera clths for a vacation. in particular, you are interestco in...

EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new...

Hello ,can you help me with this 2 assignments. They are similar to the ones you did in the past . Office 2013 - myitlab:grader - Instructions Exploring - Excel Chapter 4: Assessment Project 1 Credit...

You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare...

PROJECT STEP 1. Justin and Kaleen Millowski have always dreamed of purchasing and running a campground. Kaleen wants to be ready when a campground becomes available, so she decides to start...

EX16_XL_VOL1_GRADER_CAP_AS Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC,...

Recall that DS 6.1.4 shows the service times of customers at a fast-food restaurant who were served between 2:00 and 3:00 on a Saturday afternoon, and that DS 9.3.5 shows the service times of...

Home Depot entered fiscal 2014 with a total capitalization of $27,213 million. In 2014, debt investors received interest income of $830 million. Net income to shareholders was $6,345 million. (Assume...

BE 1 2 . 1 3 ( LO 5 ) Indicate whether the following items are capitalized or expensed in the current year. a . Purchase cost of a patent from a competitor. b . Research and development costs. c ....

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...