> > >

Excel MCQs

Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?

Select the rows for the last 10 products, then press Delete on your keyboard. Remember to undo when you're finished.

On the task pane on the right side, drag products 11 through 20 out of the Rows area.

Collapse all products from 11 through 20.

Click the filter button on the header on column A, and deselect the last 10 products.

Answer

Correct Answer: Click the filter button on the header on column A, and deselect the last 10 products.

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