> > >

Excel MCQs

Which of the following is true about PivotTables?

If a value field has null values in the base data, the field is initially brought in with a Count setting.

The format of the value fields are always in the same format as they are in the base table.

When you initially create a PivotTable, value fields are brought in to the PivotTable in a horizontal format.

Data fields automatically come in to the PivotTable in averages.

Answer

Correct Answer: If a value field has null values in the base data, the field is initially brought in with a Count setting.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it