8.) Specify that only the top20%of the ranked values in the selected range will have a brightyellow fill color (all other values will have no formatting).

Transcribed Image Text:

X FILE Paste Clipboard E3 * 1 2 3 M23 4 M23 HOME 5 M23 6 G05 7 G05 8 G05 9 B03 10 B03 11 P15 12 P15 13 P15 14 P15 15 W07 16 000 Horton storn A Calibri Fund Code▾ BIU. INSERT PAGE LAYOUT I Books Books Books - 11 A A Font - B Show Task List O fx Fund Name Children's Furniture Children's Furniture Children's Furniture Computers Computers Marble Falls Community Library DVDs DVDs DVDs DVDs e-Book Materials Front Dock Support 150 Funds And Pledges - Excel FORMULAS DATA == Alignment с 行行 ▾ Last Name Bartkus Katz Lai Lai Chiauzzi Bartkus Thompson Fraser Bartkus Foster Bartkus Nicodemus D Sandra Allan Karen Adrienne Karen Paul Chang Durne Task: EX3533 REVIEW Christina Tracy Currency $-% VIEW First Name Total Pledged Karen David Kim Kim Emil Ted Number E TABLE TOOLS $150.00 $100.00 $1,000.00 $1,000.00 $100.00 $200.00 $150.00 $25.00 $1,000.00 $50.00 $150.00 $1,000.00 $150.00 DESIGN $500.00 Question 8 of 10 Conditional Formatting Format as Table Cell Styles F Styles G H WEV Insert Σ Delete Format Cells ? 4 J ND Sort Filter Editi Time Remaining: No Limit Att X FILE Paste Clipboard E3 * 1 2 3 M23 4 M23 HOME 5 M23 6 G05 7 G05 8 G05 9 B03 10 B03 11 P15 12 P15 13 P15 14 P15 15 W07 16 000 Horton storn A Calibri Fund Code▾ BIU. INSERT PAGE LAYOUT I Books Books Books - 11 A A Font - B Show Task List O fx Fund Name Children's Furniture Children's Furniture Children's Furniture Computers Computers Marble Falls Community Library DVDs DVDs DVDs DVDs e-Book Materials Front Dock Support 150 Funds And Pledges - Excel FORMULAS DATA == Alignment с 行行 ▾ Last Name Bartkus Katz Lai Lai Chiauzzi Bartkus Thompson Fraser Bartkus Foster Bartkus Nicodemus D Sandra Allan Karen Adrienne Karen Paul Chang Durne Task: EX3533 REVIEW Christina Tracy Currency $-% VIEW First Name Total Pledged Karen David Kim Kim Emil Ted Number E TABLE TOOLS $150.00 $100.00 $1,000.00 $1,000.00 $100.00 $200.00 $150.00 $25.00 $1,000.00 $50.00 $150.00 $1,000.00 $150.00 DESIGN $500.00 Question 8 of 10 Conditional Formatting Format as Table Cell Styles F Styles G H WEV Insert Σ Delete Format Cells ? 4 J ND Sort Filter Editi Time Remaining: No Limit Att

Answer rating: 100% (QA)

SOLUTION A 1 Total pleged 2 150 100 3 4 5 6 7 8 9 ... View the full answer