1. Choose required color form Patterns tab of Format Cells dialog box
2. Choose required color on Fill Color tool in Formatting toolbar
3. Choose required color on Fill Color tool in Drawing toolbar
4. All of these
5. None of these
All of these
1. From Border tab in Format Cells dialog box
2. From Border tool in formatting toolbar
3. From Line Style tool in drawing toolbar
4. You cannot set page border in Excel
5. None of these
You cannot set page border in Excel
1. Use =if() function to format the required numbers red
2. Apply Conditional Formatting command on Format menu
3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
4. All of these
5. None of these
Apply Conditional Formatting command on Format menu
1. Cell value
2. Formula
3. Alignment
4. A and B
5. None of these
A and B
1. You can add more than one condition to check
2. You can set condition to look for Bold and apply Italics on them.
3. You can apply Font, border and pattern formats that meet the specified conditions
4. You can delete any condition from Conditional formatting dialog box if it is not required
5. None of these
You can set condition to look for Bold and apply Italics on them.
1. Sheet tabs can be colored
2. Some picture can be applied as a background of a sheet
3. You can set the column width automatically fit the amount of text
4. The width of a row and be specified manually or fit automatically
5. None of these
The width of a row and be specified manually or fit automatically
1. Hyperlink
2. Index
3. Transpose
4. Rows
5. None of these
Transpose
1. Hyperlinked
2. Placed in a word table
3. Linked
4. Embedded
5. None of these
Embedded
1. IF
2. AND
3. OR
4. NOT
5. None of these
IF
1. Insert
2. Format
3. Tools
4. Data
5. None of these
Tools