Question # 1

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

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

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

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

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

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

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

Choose an answer

Gradient

Pattern

Solid

Texture

Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result.

Choose an answer

IF

AND

OR

NOT

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

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

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

Choose an answer

= today()

=now()

= time()

= current time()

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

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

You can edit existing Excel data by pressing the

Choose an answer

F1 key

F2 key

F3 key

F4 key

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

Choose an answer

view

Insert

Tools

Format

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

To drag a selected range of data to another worksheet in the same workbook use the.

Choose an answer

Tab key

Alt key

Shift key

Ctrl key

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

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 open the sort dialog box by choosing sort from the .....menu.

Choose an answer

view

Format

Tools

Data

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

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