Field names must be: included in the data range in a Sort operation included in the data range in a Search operation included in the data range in a Search operation excluded from the data range in a Sort operation included in both Search and Sort operations both B and C Excel allows up to variable(s) in Data Table analysis. 6 5 4 2 none of the above The Advanced Filter option is accessed through the menu: Data File Edit View none of the above The field value in Excel statistical functions defines: which row is under investigation which column is under investigation which formula is under investigation which cell is under investigation none of the above The NPV (net present value) of a project (a series of cash inflow and outflow) at the IRR (internal rate of return) is: Always negative 2000 dollars 0 (zero) cannot be answered with this information always positive In Excel one of the following is not a valid cell address: $B1 B$1 $B$1 B1 They are all valid cell addresses (T, F) A cell in excel could be represented by up to four different addresses. (T, F) In Excel, cell A$1 has an absolute address. (T, F) In Excel, by default, all cells have relative addresses? (T, F) In Excel, the following formula is not valid. "=B5/$B$11" (T, F) Goal-seeking analysis is the reverse of what-if analysis