Question # 1

To active the previous cell in a pre selected range press.

Choose an answer

The Alt key

The tab key

The Enter key

None of above

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

The name box

Choose an answer

Show the location of the previously active cell

Appears the left of the formula bar

Appears below the status bar

Appears below the menu bar

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

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

If you press ........the cell accepts your typing as the contents.

Choose an answer

Enter

Ctrl + Enter

Tab

Insert

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

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

When working in the page break preview you can.

Choose an answer

View exactly where each page break occurs.

Add or remove page breaks

Change the print area

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

Each excel file is called a workbook because.

Choose an answer

It can contain text and data

It can be modified

It can contain many sheets including worksheets and chart sheets

you have to work hard to create it.

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

Choose an answer

Insert

Format

Tools

Data

A function inside another function is called a ................ function.

Choose an answer

Nested

Round

Sum

Text

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

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

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

Choose an answer

Edit

Format

View

Tools

To copy cell contents using drag and drop press the.

Choose an answer

End key

Shift key

Esc key

None of above

You can copy data or formulas

Choose an answer

With the copy paste and cut commands on the edit menu

With commands an a shortcut menu

With buttons on the standard toolbar

All of the above

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

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

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

Choose an answer