MS Excel MCQ with Answers

(A9, A99)

(A9 to A99)

(A9 : A99)

(A9 ? A99)

2 Columns will be inserted after Column F

2 Columns will be inserted after Column G

2 Columns will be inserted after Column H

2 Columns will be inserted after Column I

The Settings tab under the menu Format -> Cells

The Settings tab under the menu Data -> Validation

The Settings tab under the menu Data -> Filter -> Advanced Filter

the Settings tab under the menu Format -> Conditional Formatting

Text Only

Format Only

Contents Only

Both Contents and Format

Enter

Alt + Enter

Ctrl + Enter

Shift + Enter