Question

If you have long column labels with columns so wide that they affect the readability of a worksheet, you should first

A. decrease the column widths.
B. leave the column labels as is.
C. consider how you could shorten the column labels.
D. format the column labels.

Answer 1

C

Step-by-step explanation:

Answer 2

The answer is (C) consider how you could shorten the column labels.

The label at the top of a column is sometimes wider than the data stored in the column. Expanding a column is an option but this may mean that you will not see as many columns on a page as possible. Wrapping text is also an option but has a downside to it as well since it will make the row with great height.

Rotating the labels is also a possibility but is also not recommended. This leaves us with shortening the column labels and keep dictionary worksheet for users. As much as you can, consider using acronyms and abbreviations.