Відомо, що в області , . Чому із нижче наведеного може дорівнювати , якщо ?

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?

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

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?

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

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

What are the default settings for the Values field in a pivot table?