> > >

Excel MCQs

You've selected a range of sales data that has categories across the top row of the columns. How can you get filter buttons on this row, and alternate-row striping for the data?

Use only the Format as Table command on the Home tab. The Table command on the Insert tab will insert a table from Microsoft Word

Use the AutoFilter button on the Insert tab to get the filter buttons, then select an alternate-stripe style from the Page Layout tab

Use either the Format as Table command on the Home tab, or the Table command on the Insert tab of the Ribbon

Use only the Table command on the Insert tab. The Format as Table command on the Home tab won't insert filter buttons

Answer

Correct Answer: Use either the Format as Table command on the Home tab, or the Table command on the Insert tab of the Ribbon

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