Module 8 Working with Advanced Functions Excel EX 481 Session 8.1 Quick Check REVIEW 1. What changes occur in the appearance and size of an Excel ur in the appearance and size of an Excel table after you enter a new column header named "Phone"? 2. Whenever you enter a formula in an empty column of an Excel table, Excel automatically fills the column with the same formula. What is this called 3. If an Excel worksheet stores the cost per meal in cell 05, the number of attendees in cell Q6, and the total cost of meals in cell 07, what IF function would you enter in cell Q7 to calculate the total cost of meals (cost per meal times the number of attendees) with a minimum cost of $10,000 4. When does the AND function return a TRUE value? 5. Write the formula that displays the label "Outstanding" in cell Y5 if the amount owed (cell X5) is greater than 0 and the transaction date (cell R5) is after 3/1/2016 (stored in cell R1) but otherwise leaves the cell blank. 6. When you create a formula that references all or parts of an Excel table, what can you use to replace the specific cell or range addresses with the actual table or column header names? 7. If the formula IF (OR(B25="NY", B25="CA", B25="TX"), "Select", "Ignore") is entered in cell B26, and "PA" is entered in cell B25, what is displayed in cell B26? 8. Write the OR function that represents the following rule-"A potential enlistee in the army is not eligible to enlist if younger than 17 or older than 42." The age is stored in cell B25. Display "Eligible" if the potential enlistee can enlist. and display "Not Eligible" if the potential enlistee cannot enlist. = I ( 95