Question # 1

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

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.

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

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

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

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

Choose an answer

Edit

Format

View

Tools

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

Which function calculates your monthly mortage payment.

Choose an answer

PMT (Payment)

NPER (Numebr of periods)

PV (Present value)

All of above

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

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

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

Status indicators are located on the

Choose an answer

Vertical scroll bar

Horizontal scroll bar

Formula bar

Formatting tool bar

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

Which of the following describes how to select all the cells in a single column.

Choose an answer

Right click on column and select pick from list

Use data text to columns menu item

Left click on the gray column title button

Pressing Ctrl + A on the keyboard

Merge cells option can be applied from.

Choose an answer

Format cells dialog box alignment tab.

Formatting toolbar

Both of above

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

When you work with large worksheets you may need to

Choose an answer

Size the worksheet to fit on the specific number of pages.

Add and remove page breaks

Specify only certain print areas

All of above

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

Choose an answer

Nested

Round

Sum

Text

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

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

Choose an answer

Decimal places

Currency symbol

Both of above

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