Question # 1

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

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

Which types of charts can excel produce.

Choose an answer

Line graphs and pie charts only

Only line graphs

Bar charts line graphs and pie charts

Bar charts and line graphics only

You can use the horizontal and vertical scroll bars to.

Choose an answer

Split a worksheet into two panes

View different rows and columns

Edit the contents of a cell

View different worksheets.

Formatting a cell in number format you can't set.

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

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

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

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

Choose an answer

F3

F6

F11

F7

Gridines

Choose an answer

May be turned off for display but turned on for printing.

May be turned on or off for printing

The be turned off for display and printing.

a, b and c

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 is not a valid zoom percentage in Excel.

Choose an answer

10

100

500

300

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

None of above

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

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

What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula.

Choose an answer

Goal seek

Scenario summary report

Forecasting

Trend line

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

Choose an answer

Range

Scenario

Trend line

What if analysis

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

Choose an answer

Gradient

Pattern

Solid

Texture

Which function calculates your monthly mortage payment.

Choose an answer

PMT (Payment)

NPER (Numebr of periods)

PV (Present value)

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

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