Question # 1

When yo see a cell with a red tringle in the top right comer what does this signify.

Choose an answer

There is an error in the cell

There is a comment associated with the cell

The font color for text in the cell is red

A formula connot be entered into the cell

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

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

To create an interactive pivot table for the web you use a Microsoft Office web component called.

Choose an answer

HTML

Pivot Table field list

Pivot Table list

Pivot Table Report

What is the keyboard shortcut for creating a chart from the selected cells.

Choose an answer

F3

F6

F11

F7

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

Got function? No ? you need the insert function dialog box. How do you get it.

Choose an answer

Right click a cell and then click insert.

Click the insert menu and then click function

Type = in a cell

As of the above

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

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

Choose an answer

Edit

Ignore

Ignore all

Change

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

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

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

To copy cell contents using drag and drop press the.

Choose an answer

End key

Shift key

Esc key

None of above

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

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

What is an expression that tells how the numbers in a determined set of cells are to be calculated.

Choose an answer

Formula

Field

Data

query

When creating a vertical page break.

Choose an answer

The active cell must be A1

The active cell can be anywhere in the worksheet.

The active cell must be in row 1

The active cell must be in column A

You can open the sort dialog box by choosing sort from the .....menu.

Choose an answer

view

Format

Tools

Data

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

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

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

Choose an answer

Hyperink

Index

Transpose

Rows

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