Question

What is the purpose of the GETPIVOTDATA function?

Answer 1

Select OLAP tools in the Tools group under the Options tab, and then click Convert to Formulas. The conversion process is finished if there are no report filters. Convert to Formulas dialog box appears if there are one or more report filters. Thus, option D is correct.

What role of the GETPIVOTDATA function in pivot table?

You can extract data from a pivot table using Sheets' GETPIVOTDATA function. You must first create a pivot table before using it.

Then, you use the GETPIVOTDATA function and supply the column name and row number of the data you wish to extract in order to extract it from the table.

Therefore, The GETPIVOTDATA function returns visible data from a Pivot Table.

Learn more about pivot table here:

brainly.com/question/27945029

#SPJ1