What

was the range of the total profit made by the employees?

This question pertains to the pivot table created for the ‘orders’ data set (based on the valid employee ID’s only).

What

was the total number of orders processed by the employees during this period?

"This online quiz constitutes a formal assessment. Any sharing of information with other students and/or third parties, whether these are websites, tutors or friends about questions, responses, etc. constitute cheating. Such conduct defeats the purpose of academic progress and carries SEVERE consequences.  It may affect your academic career." 

I declare that I understand the statement above and that the work submitted is my own.  I accept the consequences of my actions if I am found cheating during this assessment.

To which ONE of the following fields do you always need to input a variable when constructing a pivot table? 

Which of the following activities can pivot tables be used for? 

Which of the following fields do you need to use when constructing a pivot table in order to perform a cross tabulation of the data?

Suppose some changes are made to the raw data set upon which the pivot table is based.  Which ONE of the following statements are true relating to how you would update the pivot table accordingly?

You may not manually type in values or text within a pivot table

It is possible to apply the usual excel functions and formatting options to all cells within a pivot table

It is not possible to copy and paste a pivot table