Answered step by step
Verified Expert Solution
Question
1 Approved Answer
8. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval
8. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2025, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell H5. Clear the conditional formatting rule from the range H5:H52 if Excel applies it. 9. Padma asks you to make it easy to filter the table based,on the contractor's specialty and starting year. Insert two slicers, one based on the Specialty field and the other based on the Start Year field. 10. Resize both slicers to a height of 2.2" and a width of 1.5. Move the Specialty slicer so its upper-left corner is in cell I4 and its lower-right corner is in cell I14. Move the Start Year slicer so its upper-left corner is in cell 34 and its lower-right cormer is in cell J14. 11. Use the slicers to filter the Contractors table to show contractors who started in 2024 or 2025 with specialties of Electronics and Movies and music. 12. Since Padma is using slicers to filter the data, hide the filter buttons in the Contractors table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started