Excel Column Width Adjustment Quiz

What is the first step to adjust the width of a column using the click and drag method?

• Click on the Home tab

• Type the desired width in a pop-up box

• Drag the dividing line between columns

• Select the entire spreadsheet

Which tab must you be on to use the Format option for changing column width?

• View

• Home

• Data

• Insert

What appears after clicking on the Format icon to change column width?

• A chart

• A formula bar

• A drop-down box

• A new worksheet

How can you adjust multiple columns to fit the text automatically?

• Use the Insert tab

• Click and drag each column individually

• Type the width for each column manually

• Select Autofit Column Width from the Format menu

What should you do if you want all selected columns to have the same width?

• Click and drag the columns to the same width

• Use the Autofit Row Height option

• Use the Sort & Filter option

• Type the desired width in the pop-up box