Question # 1

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

Where can you set the shedding color for a range of cells in Excel.

Choose an answer

Choose required color form patterns tab of format cells dialog box

Choose required color on fill color tool in formatting toolbar

Choose required color on fill color tool in drawing toolbar

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

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

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

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

Choose an answer

= today()

=now()

= time()

= current time()

Charts tips can

Choose an answer

Show the formatting of a data label

Show the name of a data series

Show the value of data point

B and C

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

Which of the following format you can decide to apply or not in auto format dialog box.

Choose an answer

Number format

Border format

Font format

All of above

When working in the page break preview you can

Choose an answer

View exactly where each page break occurs

Add or remover page breaks

Change the print area

All of above

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

Choose an answer

Hyperink

Index

Transpose

Rows

Which function calculates your monthly mortage payment.

Choose an answer

PMT (Payment)

NPER (Numebr of periods)

PV (Present value)

All of above

You can edit existing Excel data by pressing the

Choose an answer

F1 key

F2 key

F3 key

F4 key

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

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

Choose an answer

Edit

Format

View

Tools

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

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

Choose an answer

view

Insert

Tools

Format

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

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

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

Choose an answer

Enter

Ctrl + Enter

Tab

Insert

Which of the following is not a basic step in creating a worksheet.

Choose an answer

Save the workbook

Modify the worksheet

Enter text and data

Copy the worksheet

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