Italicize the contents of the range A3:B3, change the font to Times New Roman, and then change the font color to Orange, Accent 2 (6th column, 1st row of the Theme Colors palette). 4. 5. Format cell B3 using the Short Date (e.g., 3/13/2018) number format. 6. Use the Format Painter to copy the format from cell A6 to the range B6:G6 7. In cell F7, create a formula that calculates the salary for Joan Dickinson. Her is calculated by adding her base salary (cell B7) to her total bonus (cel E7). (Hint: Do not use the SUM function.) and the soring in i / e tera To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10 rested Kelly wants to view employees' bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan's total bonus (cell E7) by her base salary (cell B7) 8. Workers' Compensation Report Date 1/30/2019 Weekly Pay mployee Base Salaries Bonus Multiplier Bonus Rate Total Bonus Total Salaries Bonus Percentage Joan Dickinson Marley Bubble Bob Roberts $350 $400 $360 $420 $383 20 20 15 70 40 20 150 10 0 Peggy Moore 1 Average