There is a table on the sheet "Car Information" that lists the statistics for a variety of vehicle models, and it spans from A2 to E9 on that sheet, as shown below. This information would be useful for a variety of sheets in our spreadsheet, and so we would like to be able to easily reference the range. What does Excel have that can do this? How would you create this in Excel? Be specific. If talking about cells, reference the specific cells. If entering data, say where it will be entered. For reference, data on Car Information sheet shown below. You are work in HR for Regional Hospital. Because your hospital got good ratings for the last quarter, there has been some additional funding, and the hospital has decided to give a bonus of S500 to full-time employees and $100 to part-time employees. For the data shown below, write the IF statement that would go in cell C2 and be copied down the C column