Question # 1

You can activate a cell by

Choose an answer

Pressing the tab key

Clicking the cell

Pressing an arrow key

All of above

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

Choose an answer

Nested

Round

Sum

Text

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

Choose an answer

Edit

Format

View

Tools

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

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

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

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

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

Choose an answer

Enter

Ctrl + Enter

Tab

Insert

In a worksheet yo can select

Choose an answer

The entire worksheet

Rows

Columns

a,b and c

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

Choose an answer

Formula

Function

Series

Syntax

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

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

What term refers to a specific set of values saved with the workbook.

Choose an answer

Range

Scenario

Trend line

What if analysis

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

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

Choose an answer

= today()

=now()

= time()

= current time()

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

Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following.

Choose an answer

Rows and columns

Headings

Speed

None

Hyperlink cannot be

Choose an answer

Special shapes like stars and banners

Drawing objects like rectangles ovals

Pictures

All can be hyperlinks

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

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

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