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 A6:G6 and click the Center icon on the Home tab.

Answer 3

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

Answer 4

Don’t know

Answer 5

Double click on any line between the column labels.

Answer 6

Select each column individually and resize them one at a time.

Answer 7

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

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?