From LibreTexts, under CC BY 4.0, as the source states it; its equations are written in TeX, which the PDF shows typeset. This page at LibreTexts.
10.11: Chapter Review - Written Questions
Opening the book…
Written Questions
27 .
What are the main differences between a cell range and an array?
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?
This page titled 10.11: Chapter Review - Written Questions was last modified on Tue, 13 Feb 2024 04:53:40 GMT and is shared under a CC BY 4.0 license and was authored, remixed, and/or curated by OpenStax via source content that was edited to the style and standards of the LibreTexts platform.