28 .
How is a Data Table different from a spreadsheet? Explain the objectives of using a Data Table.
29 .
Why is the order of operations important? What role does it play when writing your formulas in Excel? Explain.
30 .
What is the difference between using array formulas and simply using a function?
31 .
When working with large datasets, what can go wrong?
32 .
Explain the purpose of using the IF function in dataset analysis.
33 .
What sort of complications can arise from a client with highly fluctuating unit orders? How is the standard deviation useful in this case?
34 .
What is the benefit of the drag-and-drop interface of PivotTables?
35 .
How should the raw source data of a PivotTable be formatted? Explain why.
36 .
Describe how to determine what kind of PivotTable variables you can use in a graph.
37 .
Why would formulas need to be audited?
38 .
Why is it important to install the Inquire add-in
before
doing any precedents and dependents diagrams?
39 .
Describe the purpose of using the Watch Window.
40 .
What is the difference between using the Themes tool and formatting a set of tables by copying the formatting? Explain.
41 .
Why would you need to create your own theme?
42 .
Why is formatting important?