Question # 1

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

Choose an answer

Sever

Source

Client

None

What does the VLOOKUP function do.

Choose an answer

Looks up text that contain

Checks whether text is the same in one cell as in the next

Finds related records

All of above

You can open the scenario manager dialog box by choosing scenarios from the ..............menu

Choose an answer

view

Insert

Tools

Format

Macros are 'run' or executed from the ...........menu

Choose an answer

Insert

Format

Tools

Data

You can add an image to a template by clicking the insert picture from file button on the toolbar

Choose an answer

Standard

Formatting

Drawing

Picture

When you insert an excel file into a word document the data are.

Choose an answer

Hyperlinked

Placed in a word table

Linked

Embedded

To center worksheet titles across a range of cell you must.

Choose an answer

Select the cells containing the title text and use the fill handle to center the text across a range of cells.

Widen the columns

Select the cells containing the title text and use the fill handle to center the text across a range of cells.

Widen the column

Which of the following format you can decide to apply or not in auto format dialog box.

Choose an answer

Number format

Border format

Font format

All of above

You can use the horizontal and vertical scroll bars to.

Choose an answer

Split a worksheet into two panes

View different rows and columns

Edit the contents of a cell

View different worksheets.

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

Which of the following methods cannot be used to edit the content of cell.

Choose an answer

Pressing the Alt key

Clicking the formula bar

Pressing F2

Double clicking the cell

Gridines

Choose an answer

May be turned off for display but turned on for printing.

May be turned on or off for printing

The be turned off for display and printing.

a, b and c

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

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

Charts tips can

Choose an answer

Show the formatting of a data label

Show the name of a data series

Show the value of data point

B and C

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

To protect a worksheet, you can choose protection and the protect sheet from the menu.

Choose an answer

Edit

Tools

Data

Format

Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following.

Choose an answer

Rows and columns

Headings

Speed

None

What do we call a computer program that organizes data in rows and columns of cells? You might use the type of program to keep a record of the money you keep a record of the money you earned moving lawns over the summer.

Choose an answer

Spread sheet program

Database program

Word processor program

Desktop publisher program

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

You can edit existing Excel data by pressing the

Choose an answer

F1 key

F2 key

F3 key

F4 key

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