4

# Which of the following is not true regarding Conditional Formatting?

You can add more than one condition to check

You can set condition to look for Bold and apply Italics on them

You can apply Font, border and pattern formats that meets the specified conditions

You can delete any condition from Conditional Formatting dialog box if it is not requried

B. You can set condition to look for Bold and apply Italics on them

4

# What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B\$10)

An absolute cell address is created

Cell address will change when it is copied to another cell

The sheet tab is changed

The status bar does not display the cell address

4

Formula bar

Status Bar

Name Box

Title Bar

4

Pmt

Average

Max

Sum

4

# Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Logical

Math & Trigonometry

Statistical

Financial

4

# Edit >> Delete command

Deletes the content of a cell

Deletes Formats of cell

Deletes the comment of cell

Deletes selected cells

4

Title bar

Formula bar

Sheet tabs

4

=

+

(

@

4

Dialog box

Worksheet

Clipboard

Toolbar

4

Smart Tip

Cell Tip

Web Tip

Soft Tip

4

Word

Smart cell

Excel

Lotus 1-2-3

4

# Each excel file is called a workbook because

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

4

# Which of the following options is not located in the Page Setup dialog box?

Page Break Preview

Page Orientation

Margins

4

# Which button do you click to add up a series of numbers?

The autosum button

The Formula button

The quicktotal button

The total button

4

# To remove the content of selected cells you must issue ______ command

Edit >> Delete

Edit >> Clear >> Contents

Edit >> Clear >> All

Data >> Delete

4

# How can you print three copies of a workbook?

Select File > Properties form the menu and type 3 in the Copies to print text box

Select File > Print from the menu and type 3 in the Number of copies text box

Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made

Press Ctrl+P+3

4

Subtract

Divide

SQRT

4

# You can use the formula pallette to

format cells containing numbers

create and edit formula containing functions

enter assumptions data

copy a range of cells

4

Title bar

Formula bar

Standard toolbar

4

Efficiency

Description

Clarity

4

# You cannot link excel worksheet data to a word document

With the right drag method

With the copy and paste special commands

With the copy and paste buttons on the standard toolbar

4

WINDOWS

DOS

UNIX

OS/2

4

# Which of the following is a correct order of precedence in formula calculation?

Multiplication and division exponentiation positive and negative values

Multiplication and division, positive and negative values, addition and subtraction

Addition and subtraction, positive and negative values, exponentiation

All of above

4

( quote )

= ( equal )

_ ( underscore )

( apostrophe )

4

insert

file

tools

view

4

# You can use the horizontal and vertical scroll bars to

Split a worksheet into two panes

View different rows and columns edit the contents of a cell

Edit the contents of a cell

view different worksheets

4

# You can use drag-and-drop to embed excel worksheet data in a word document

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

None of above

4

Paper

Margin

Layout

Orientation

4

Server

Destination

Client

Both b and c

4

# To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Unfreeze panes command on the window menu

Freeze panes command on the window menu

Hold titles command on the edit menu

Split command on the window menu