Question # 1

If you need a text to show vertically in a cell .how will you achieve this.

Choose an answer

Choose vertical on text alignment in format cells dialog box

Choose 90 degrees in orientation of format cells dialog box

Choose distributed from the vertical drop down list of format cells dialog box

Choose center Across selection from horizontal combo box in format cells dialog box

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

Choose an answer

Sever

Source

Client

None

Which function will you use to enter current time in a worksheet cell.

Choose an answer

= today()

=now()

= time()

= current time()

"tr 1,, tr 2,tr 3" is an example of a

Choose an answer

Formula

Function

Series

Syntax

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

What function displays row data in a column or column data in a row.

Choose an answer

Hyperink

Index

Transpose

Rows

The autofill feature

Choose an answer

Extends a sequential series of data

Automatically adds a range of cell values

Applies a boarder around selected cells.

None of above

A data map is helpful

Choose an answer

When you have too much data to chart

To show a geographic distribution of data

To compare data points

To show changes in data over time

What term described a back ground that appears as a grainy non smooth surface.

Choose an answer

Gradient

Pattern

Solid

Texture

When you print preview a worksheet.

Choose an answer

The entire worksheet is displayed

The selected range is displayed

The active portion of the worksheet is displayed

a , b and c

Status indicators are located on the

Choose an answer

Vertical scroll bar

Horizontal scroll bar

Formula bar

Formatting tool bar

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

You can quickly change the appearance of your work by choosing Auto format from the Menu.

Choose an answer

Edit

Format

View

Tools

You can print only an embedded chart by

Choose an answer

Moving the chart to a chart sheet before you print.

Formatting the chart before you print

Selecting the chart before you print

a and c

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

How do you change column width to fit the contents.

Choose an answer

Single click the boundary to the left to the column heading

Double click the boundary to the right of the column heading

Press Alt and single click any ware is the column

All of above

You can activate a cell by

Choose an answer

Pressing the tab key

Clicking the cell

Pressing an arrow key

All of above

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

Which is following is not an option in the spelling dialog box.

Choose an answer

Edit

Ignore

Ignore all

Change

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

Choose an answer

Insert

Format

Tools

Data

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