Question # 1

Can you set 0.5 inch left indentation for a cell in Excel.

Choose an answer

Excel does not have indentation feature

You can specify indentation only if you turn the rulers on

Indentation can be set from format cells dialog box

The indentation can be specified only when printing

When working in the page break preview you can.

Choose an answer

View exactly where each page break occurs.

Add or remove page breaks

Change the print area

All of above

You can check the conditions against ______ when applying conditional formating.

Choose an answer

Cell value

Formula

Both of above

None of above

Which of the following setup options can not be set in the page setup dialog box.

Choose an answer

Printer selection

Vertical or horizontal placement

Orientation

Raw and column titles

When Integrating MS-Word and Excel, Word in usually the

Choose an answer

Sever

Source

Client

None

If you press ........the cell accepts your typing as the contents.

Choose an answer

Enter

Ctrl + Enter

Tab

Insert

Which of the following is not a valid zoom percentage in Excel.

Choose an answer

10

100

500

300

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

Formatting a cell in number format you can't set.

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

Where can you set the shedding color for a range of cells in Excel.

Choose an answer

Choose required color form patterns tab of format cells dialog box

Choose required color on fill color tool in formatting toolbar

Choose required color on fill color tool in drawing toolbar

All of above

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

Choose an answer

G1 - G10

B1 ,G10

B1:G10

B1;G10

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

When yu use the fill effects in the format data series dialog box you can not.

Choose an answer

Rotate text on the chart

Select a fore ground color

Select a pattern

Select a background color

How can you remove borders applied in cells.

Choose an answer

Choose none on border tab of format cells.

Open the list on border tool in formatting toolbar then choose fist tool

Both of above

None of above

You can copy data or formulas

Choose an answer

With the copy paste and cut commands on the edit menu

With commands an a shortcut menu

With buttons on the standard toolbar

All of the above

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

You can activate a cell by

Choose an answer

Pressing the tab key

Clicking the cell

Pressing an arrow key

All of above

When you work with large worksheets you may need to

Choose an answer

Size the worksheet to fit on the specific number of pages.

Add and remove page breaks

Specify only certain print areas

All of above

You can set page border in Excel from

Choose an answer

From border tab in format cells dialog box

From Border tool in formatting toolbar

From line style tool in Drawing toolbar

You can not set page border in Excel

To hold row and column title sin place so that they do not scroll when you scroll a worksheet click the

Choose an answer

Unfreeze panes command on the window menu

Freeze panes command on the window menu

Hold title command on the edit menu

Spilt command on the window menu

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

More Classes

Other Links

PPSC Computer Science Chapter 4 Microsoft Excel Online Test MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer