Question 1 (1 point) Saved Emily tries to find what's the maximum loan amount she can borrow to buy a new house with a 20 yrs, 3.5% interest rate mortgage. She wants her monthly payment not greater than $2000. Which of the following Excel function/tool is the best one she can use to find out? she could use the Scenario Manager command O she could use the Goal Seek command She could use an Excel Table to solve ( she could use the Data Table command Question 2 (1 point) makes the data easier to read and understand because it adds a visual or graphical element to the cells or values A scroll bar An Excel table Conditional formatting A Data table Question 3 (1 point) In a Pivot Table, to extract a specific data (e.g. specified by field names), you can use Slicer O GETPIVOTDATA function Structured reference Question 4 (1 point) Which of the following statement about seasonal index is FALSE? Deseasonalization helps to understand the real trend of a time series. Seasonal indexes across a cycle must average out to 1 Seasonal index must be between 0 and 1 Question 5 (1 point) You can extend the input values for a Data Table and the Data Table will extend itself automatically to include those values. True False