Q. In Microsoft Excel 2019, the pivot table error ‘field name is not valid’ usually appears because:
(A) one or more row heading cells in the source data are blank.
(B) one or more of the column heading cells in the source data is blank.
(C) one or more column cells in the source data are blank.
(D) the worksheet with the pivot table is full.
Answer:B
(A) one or more row heading cells in the source data are blank.
(B) one or more of the column heading cells in the source data is blank.
(C) one or more column cells in the source data are blank.
(D) the worksheet with the pivot table is full.
Answer: