Suppose you want to center the title you have in cell A6 over the data table in A7:G40. Which method is the best?

Answer 1

Select cells A6:G6, right click, choose Format Cells, and set the horizontal alignment to “Center Across Selection”

Answer 2

Select cells A6:G6 and click the “Merge and Center” button on the Home tab

Answer 3

Select A6:G6 and click the Center icon on the Home tab

Answer 4

Don’t know

Answer 5

Select each column individually and resize them one at a time

Answer 6

Right click the column header and select “Shrink to Fit”

Answer 7

Double click on any line between the column labels

Answer 8

Don’t know

Answer 9

Select cells A10:A20, rotate the text 90 degrees and select Center Across Selection

Answer 10

Select cells A10:A20 and select the Merge and Center button

Answer 11

Merge cells A10:A20, rotate the text 90 degrees and select Center Vertically

Answer 12

Don’t know

Suppose you have selected columns B:E and you want them resized to fit your data without excess space. Which method is the most efficient?