MS Excel MCQs

Question 1

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Accepted Answer

All of above

Answer

Number format

Answer

Border format

Answer

Font format

Question 2

How can you remove borders applied in cells?

Accepted Answer

Both of above

Answer

Choose None on Border tab of Format cells

Answer

Open the list on Border tool in Format Cell toolbar then choose first tool (none)

Answer

None of above

Question 3

Where can you set the shading color for a range of cells in Excel?

Accepted Answer

All of above

Answer

Choose required color form Patterns tab of Format Cells dialog box

Answer

Choose required color on Fill Color tool in Formatting toolbar

Answer

Choose required color on Fill Color tool in Drawing toolbar

Question 4

You can set Page Border in Excel from

Accepted Answer

You can not set page border in Excel

Answer

From Border tab in Format Cells dialog box

Answer

From Border tool in Formatting toolbar

Answer

From Line Style tool in Drawing toolbar

Question 5

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

Accepted Answer

Apply Conditional Formatting command on Format menu

Answer

Use =if() function to format the required numbers red

Answer

Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

Answer

All of above

Question 6

You can check the conditions against __________ when applying conditional formatting

Accepted Answer

Both of above

Answer

Cell value

Answer

Formula

Answer

None of above

Question 7

Which of the following is not true regarding Conditional Formatting?

Accepted Answer

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

Answer

You can add more than one condition to check

Answer

You can apply Font, border and pattern formats that meets the specified conditions

Answer

You can delete any condition from Conditional Formatting dialog box if it is not requried

Question 8

Which of the following is invalid statement?

Accepted Answer

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

Answer

Sheet tabs can be colored

Answer

Some picture can be applied as a background of a sheet

Answer

You can set the column width automatically fit the amount of text

Question 9

You can use the formula palette to

Accepted Answer

Create and edit formula containing functions

Answer

Format cells containing numbers

Answer

Enter assumptions data

Answer

Copy a range of cells