1. For each of the Excel capabilities/functions below, describe a real world situation where you might use it (that you personally come up with). Describe the use in a Word document and then show Excel being used to assist with the describe situation. You can combine topics onto worksheets as shown below. a. Worksheet 1: i. SUMPRODUCT function ii. Nested "IF" statement iii. COUNTIF statement iv. V. Set up a cell to validate data entered by user Set up a cell using conditional formatting to change color based on value entered b. Worksheet 2: i. VLOOKUP (or XLOOKUP) function. ii. Add a filter to a column to enable limiting the data that is shown to user-selected categories. c. Worksheet 3: i. Ability to generate numbers coming from a Normal distribution. ii. Ability to automatically generate a histogram from collected data