1. Explain and list the order of precedence rules followed by Excel in determining which mathematical operation to perform first in a formula.
2. List three Excel chart types with comments on when each type would be used.
3. Type the format of the SUMIF function showing the arguments within the parentheses with a brief description of each argument.
4. Briefly explain the terms Fields, Field Names and Records as used in Excel Tables.
5. List and briefly describe three ways to run a macro in Excel.
6. Define an Excel What-if Analysis. Include the terms Input Cellsand Dependent Cell in your definition.
7. Describe the use of source data in a PivotTable and explain its relationship to the PivotTable Report.
8. List and briefly explain the steps in planning to exchange data between different computer programs.