Question # 1

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 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

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 protect a worksheet, you can choose protection and the protect sheet from the menu.

Choose an answer

Edit

Tools

Data

Format

To copy cell contents using drag and drop press the.

Choose an answer

End key

Shift key

Esc key

None of above

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

Choose an answer

Hyperink

Index

Transpose

Rows

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

Choose an answer

Gradient

Pattern

Solid

Texture

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

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

Choose an answer

Formula

Function

Series

Syntax

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

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

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

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

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

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

Which of the following is not a valid zoom percentage in Excel.

Choose an answer

10

100

500

300

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

Which of the following methods cannot be used to edit the content of cell.

Choose an answer

Pressing the Alt key

Clicking the formula bar

Pressing F2

Double clicking the cell

What is the keyboard shortcut for creating a chart from the selected cells.

Choose an answer

F3

F6

F11

F7

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

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

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