Question # 1

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 Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed.

Choose an answer

Format Report

Pivot table

Refresh Data

Show detail

When the formula bar is activated you can see.

Choose an answer

The Edit formula button

The cancel button

The Enter button

All of above

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

Choose an answer

Formula

Function

Series

Syntax

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

Choose an answer

view

Insert

Tools

Format

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

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

Choose an answer

= today()

=now()

= time()

= current time()

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

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

Choose an answer

Gradient

Pattern

Solid

Texture

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

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

To insert three columns between columns D and E you would.

Choose an answer

Select column D

Select column E

Select columns E, F and G

Select column D , E and F

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

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.

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

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

Choose an answer

view

Format

Tools

Data

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

Which of the following methods can not be used to enter data in a cell.

Choose an answer

Pressing an arrow key

Pressing the tab key

Pressing the Esc key

Clicking the enter button to the formula bar

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

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

Pre-made sheet formats like simple classic accounting colorful can be applied from.

Choose an answer

From format >> cells

From Table >> autoformat

From format >> autoformat

All 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

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