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

5
Correct Answer :

All of these


Explanation :
No Explanation available for this question

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

5
Correct Answer :

You cannot set page border in Excel


Explanation :
No Explanation available for this question

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

5
Correct Answer :

Apply Conditional Formatting command on Format menu


Explanation :
No Explanation available for this question

1.  Cell value

2.  Formula

3.  Alignment

4.  A and B

5.  None of these

5
Correct Answer :

A and B


Explanation :
No Explanation available for this question

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

5
Correct Answer :

You can set condition to look for Bold and apply Italics on them.


Explanation :
No Explanation available for this question

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

5
Correct Answer :

The width of a row and be specified manually or fit automatically


Explanation :
No Explanation available for this question

1.  Hyperlink

2.  Index

3.  Transpose

4.  Rows

5.  None of these

5
Correct Answer :

Transpose


Explanation :
No Explanation available for this question

1.  Hyperlinked

2.  Placed in a word table

3.  Linked

4.  Embedded

5.  None of these

5
Correct Answer :

Embedded


Explanation :
No Explanation available for this question

1.  IF

2.  AND

3.  OR

4.  NOT

5.  None of these

5
Correct Answer :

IF


Explanation :
No Explanation available for this question

1.  Insert

2.  Format

3.  Tools

4.  Data

5.  None of these

5
Correct Answer :

Tools


Explanation :
No Explanation available for this question

Interview Questions

MongoDB
Java Script
Node JS
PHP
JQuery
Python