Reference no: EM132176241
1. A MATCH function returns the value of a given position.
True or False
2. A NOT function reverses the truth of a logical test.
True or False
3. A PivotChart has live updates as you change the PivotTable.
True or False
4. A PivotChart has no filters available.
True or False
5. A PivotTable can display no subtotals and no grand totals.
True or False
6. A PivotTable can only display one summary statistic at a time.
True or False
7. A Scenario Manager Summary report displays the single best input to achieve the desired outcome.
True or False
8. A loan amortization table is a schedule that calculates the interest per payment period, principal repayment for each payment, and remaining balance after each payment is made.
True or False
9. An objective cell is required to complete a Solver model
True or False
10. DSTDEV calculates the standard deviation of a sample population in a database range.
True or False