MS Excel MCQs - Fine MCQs

Fine MCQs

Fine Preparation

Fine MCQs

Fine Preparation

MS Excel - Toolbars & Menus

Title bar in MS-Excel displays name of the __________ ?

Worksheet

Workbook

Formula

Location

None

You can set Page Border in Excel from

From Border tab in Format Cells dialog box

From Border tool in Formatting toolbar

You cannot set page border in Excel

None

How can you show or hide the gridlines in Excel Worksheet?

Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

Click Gridline tool on Forms toolbar

Both of above

None of above

None

Where can you change automatic or manual calculation mode in Excel?

Double CAL indicator on status bar

Go to Tools >> Options >> Calculation and mark the corresponding radio button

Both of above

None of above

None

In MS Excel to delete duplicate values which menu is used?

Data

Tools

Formatting

Layout

None

Time's up