A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

A. Number

B. Character

C. Label

D. Date/time

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

A. Pressing an arrow key

B. Pressing the Tab key

C. Pressing the Esc key

D. Clicking on the formula bar

A. DOC

B. XLS

C. 123

D. WK1

A. With the copy, paste and cut commands on the edit menu

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

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

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

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

D. Press Ctrl+P+3

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

A. Delete contents

B. Delete notes

C. Delete cells

D. Delete formats

A. Save workbook

B. Modifiy the worksheet

C. Enter text and data

D. Copy the worksheet

A. When you use multiplication, division, or exponentiation in a formula

B. When you use addition and subtraction in a formula

C. Because excel uses hidden decimal places in computation

D. When you show the results of formulas with different decimal places that the calculated results

A. Multiplication and division exponentiation positive and negative values

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

C. Addition and subtraction, positive and negative values, exponentiation

D. All of above

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

B. Click Gridline tool on Forms toolbar

C. Both of above

D. None of above

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

A. =10+50

B. 10+50

C. =10+50

D. =B7+14

A. Reference tabs

B. Position tabs

C. Location tabs

D. Sheet tabs

A. Square

B. Percentage

C. Goal Seek

D. Divide

A. You can search for bold and replace with italics

B. You can decide whether to look for the whole word or not

C. You can search in formula too

D. You can search by rows or columns or sheets

A. Accessing

B. Referencing

C. Updating

D. Functioning

A. standard formulas

B. array formula

C. complex formulas

D. smart formula

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

A. VisiCalc

B. Lotus 1-2-3

C. Excel

D. StarCalc

A. Visual Basic

B. C

C. Visual C++

D. Java

A. is defined by a bold border around the cell

B. Receives the data the user enters

C. It is the formula bar

D. Only A and B

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

A. Select the cells containing the title text plus the range over which the title text is to be centered

B. Widen the columns

C. Select the cells containing the title text plus the range over which the title text is to be enfettered

D. Format the cells with the comma style

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

A. Contents

B. Objects

C. Scenarios

D. All of above