- If you need a text to show vertically in a cell. How will you achieve this?
- Choose Vertical on Text alignment in Format Cells dialog box
- Choose 90 Degrees in Orientation of Format Cells dialog box
- Choose Distributed from the Vertical drop down list of Format Cells dialog box
- Choose Center Across Selection from Horizontal combo box in Format Cells dialog box
- Can you set 0.5 inch left indentation for a cell in Excel?
- Excel does not have indentation feature
- You can specify indentation only if you turn the rulers on
- Indentation can be set from Format Cells dialog box
- The indentation can be specified only when printing
- You can automatically adjust the size of text in a cell if they do not fit in width by
- Double clicking on the right border of column header
- From Format choose Columns and then Autofit Selection
- From Format Cells dialog box mark Shrink to fit check box
- All of above
- Formatting a cell in Currency, you can specify
- Decimal Places
- Currency Symbol
- Both of above
- None of above
- Formatting a cell in Number format you can’t set
- Decimal Places
- Use 1000 separator
- Negative numbers
- Currency Symbol