Problem
i. What are three benefits that can be immediately realized when a plain data set is converted to an Excel table?
ii. You are talking with a colleague who mentions that the SUBTOTAL function performs sum, average, count, or other functions and questions why a person would use that function when the SUM, AVERAGE, and COUNT functions already exist. What is the difference between using the SUBTOTAL to sum versus the SUM function?
iii. What is an Excel database? Explain how database functions may differ from non-database functions.
iv. What type of data would work well for the row and column labels within a PivotTable? What are some examples?
v. Describe two benefits of using an Excel PivotChart rather than an Excel Pivot-Table.