MSME - Sec B - 32 Batch

_____ option is used for the extra long texts into multiple lines

• Orientation

• Merge & Centre

• Wrap text

• Format Painter

Applying the formatting in different places of an Excel sheet is done by ___ function

• Orientation

• Merge & Centre

• Wrap Text

• Format Painter

Ctl +shift +L is a short key used for __

• Sort A to Z

• Sort Z to A

• Filter

• Custom Sort

To rotate the text vertically and horizontally ___ option of excel is used

• Wrap-Text

• Orientation

• Merge & Center

• Format Painter

___option is used to Keep rows and columns visible while the rest of the worksheet rolls

• Custom View

• Page Break preview

• Navigation

• Freeze Panes

←0.00 option is used for ___

• Increase Decimal

• Decrease Decimal

• Both Increase and Decrease Decimal

• Neither Increase nor Decrease Decimal

→0.00 option is used for ___

• Increase Decimal

• Decrease Decimal

• Both Increase and Decrease Decimal

• Neither Increase nor Decrease Decimal

Splitting a single column of text into multiple columns is done by using ___

• Flash Fill

• Data Validation

• Text to Columns

• Consolidate

To restrict the type of data or the values that users enter into a cell, like a dropdown list, is done by __

• Flash Fill

• Data Validation

• Text to Columns

• Consolidate

Ctrl + E is used to do___

• Flash Fill

• Data Validation

• Text to Columns

• Consolidate