will rate

Statement Analysis of Valentine's spending Points Task 1 Apply conditional formatting to the spending categories in year 2020 (row 22). The formatting should highlight the highest spend (top 1) cateogry. The result should be formatted with green fill with dark green text. Format all the spending numbers in the table to I decimal place (the columns labeled Candy to Gift Cards). Note that the data is already centered. Do not change the orientation (left, center, right). Press CTRL+S to save after each problem 1 Year Candy Flowers Clothing 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 1.2000 1.5000 1.5000 1.7000 1.4000 1.7000 1.8000 1.7000 1.8000 1.8000 2.4000 1.7000 1.7000 1.9000 1.9000 1.9000 2.1000 2.0000 2.0000 2.0000 1.9000 2.3000 Jewelry 3.0000 3.5000 4.1000 4.4000 3.9000 4.8000 4.4000 4.3000 4.7000 3.9000 5.8000 Valentines Spend (SB) Greeting cards an evening out 0.8000 3.3000 1.1000 3.4000 1.0000 3.6000 1.2000 4.0000 1.0000 3.5000 1.0000 3.6000 1. 1000 4.5000 1.0000 3.8000 0.9000 3.7000 0.9000 3.5000 1.3000 4.3000 1.5000 1.6000 1.5000 1.6000 1.7000 2.0000 2.0000 1.9000 1.9000 2.1000 2.9000 Gift card/gift certificate 1.2000 1.5000 1.2000 1.5000 1.2000 1.5000 1.7000 1.4000 1.5000 1.3000 2.0000 Description or Problem Statement Part Pole 1 1 Creating Data Tik You've been tracking your marathon triting in the table below, but you scadentally deleted the distance values. Use the Fill Series Tool to fill in the Distance clumn with values from 5 toll CIX16030 (27) in increments of 3. When you do, the Speed formula will calculate correctly Answer the question about fill in the green call (015) Add to call it with the mode. 12/2001 1 theus CTRLS to whereach problem When you wed the fill resto, did you select or columns to fill the table Demi Time minute 13 44 72 90 100 145 14 16 162