Microsoft Excel Questions

MCQ bookmark_border

1.

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

A

Number format

B

Border format

C

Font format

D

All of above

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

How can you remove borders applied in cells?

A

Choose None on Border tab of Format cells

B

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

C

Both of above

D

None of above

Correct Answer: C

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

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

A

Choose required color form Patterns tab of Format Cells dialog box

B

Choose required color on Fill Color tool in Formatting toolbar

C

Choose required color on Fill Color tool in Drawing toolbar

D

All of above

Correct Answer: D

The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

You can set Page Border in Excel from

A

From Border tab in Format Cells dialog box

B

From Border tool in Formatting toolbar

C

From Line Style tool in Drawing toolbar

D

You can not set page border in Excel

Correct Answer: D

There is no option to set page border in Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

You can set Page Border in Excel from

A

From Border tab in Format Cells dialog box

B

From Border tool in Formatting toolbar

C

From Line Style tool in Drawing toolbar

D

You can not set page border in Excel

Correct Answer: D

There is no option to set page border in Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

You can check the conditions against __________ when applying conditional formatting

A

Cell value

B

Formula

C

Both of above

D

None of above

Correct Answer: C

We can check the conditions against Cell value or Formula when applying conditional formatting.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

Which of the following is not true regarding Conditional Formatting?

A

You can add more than one condition to check

B

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

C

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

D

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

Correct Answer: B

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

Which of the following is invalid statement?

A

Sheet tabs can be colored

B

Some picture can be applied as a background of a sheet

C

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

D

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

Correct Answer: D

The width of a row and be specified manually or fit automatically is invalid statement.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

You can use the formula palette to

A

Format cells containing numbers

B

Create and edit formula containing functions

C

Enter assumptions data

D

Copy a range of cells

Correct Answer: B

Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

You can use the formula palette to

A

Format cells containing numbers

B

Create and edit formula containing functions

C

Enter assumptions data

D

Copy a range of cells

Correct Answer: B

Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.

Check Answer report_problem Report forum Discussion