Question # 1

Which of the following is not a worksheet design criterion.

Choose an answer

Efficiency

Auditability

Description

Clarity

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

Choose an answer

10

100

500

300

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

Choose an answer

Edit

Ignore

Ignore all

Change

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

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

To hold row and column title sin place so that they do not scroll when you scroll a worksheet click the

Choose an answer

Unfreeze panes command on the window menu

Freeze panes command on the window menu

Hold title command on the edit menu

Spilt command on the window menu

What is a quick way to extend these numbers to a longer sequence for instance 1 through 20

Choose an answer

Select both cells and then drag the fill handle over the range you want for instance 18 more rows.

Select the range you want include both cells point to till on the edit menu, and then click down.

Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the paste button and than click paste special

All above

You can check the conditions against ______ when applying conditional formating.

Choose an answer

Cell value

Formula

Both of above

None of above

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

Choose an answer

Formula

Function

Series

Syntax

Excel is a.

Choose an answer

Graphic program

Word processor

A spread sheet

None of these

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

Choose an answer

view

Insert

Tools

Format

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

How are data organized in a spread sheet.

Choose an answer

Lines and spaces

Layers and planes

Rows and columns

Height and width

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

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.

When working in the page break preview you can.

Choose an answer

View exactly where each page break occurs.

Add or remove page breaks

Change the print area

All of above

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

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

Choose an answer

Decimal places

Currency symbol

Both of above

None of above

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

Choose an answer

Edit

Format

View

Tools

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

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

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