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

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

Choose an answer

Nested

Round

Sum

Text

Which is following is not an option in the spelling dialog box.

Choose an answer

Edit

Ignore

Ignore all

Change

When creating a vertical page break.

Choose an answer

The active cell must be A1

The active cell can be anywhere in the worksheet.

The active cell must be in row 1

The active cell must be in column A

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

Choose an answer

Range

Scenario

Trend line

What if analysis

The spelling tool is placed on _____________ toobar.

Choose an answer

Standard

Formatting

Drawing

Reviewing

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

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

You can edit existing Excel data by pressing the

Choose an answer

F1 key

F2 key

F3 key

F4 key

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

What do we call a computer program that organizes data in rows and columns of cells? You might use the type of program to keep a record of the money you keep a record of the money you earned moving lawns over the summer.

Choose an answer

Spread sheet program

Database program

Word processor program

Desktop publisher program

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

Choose an answer

view

Insert

Tools

Format

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

Choose an answer

Hyperink

Index

Transpose

Rows

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

Choose an answer

10

100

500

300

What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed.

Choose an answer

Format Report

Pivot table

Refresh Data

Show detail

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

Which function calculates your monthly mortage payment.

Choose an answer

PMT (Payment)

NPER (Numebr of periods)

PV (Present value)

All of above

To protect a worksheet, you can choose protection and the protect sheet from the menu.

Choose an answer

Edit

Tools

Data

Format

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.

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