Excel 2010 Test Questions - 14

66. What is the basic mathematical order that Excel 2010 follows when more than one arithmetic operator is involved in a formula?

A.    Numerical progression

B.     Order of operation

C.     Process of elimination

D.    Mathematical method

Answer: B

67. Which mode enables you to use the mouse to select cells for use in a formula?

A.    Edit mode

B.     Selection mode

C.     Formula mode

D.    Point mode

Answer: D

68. How are a cell reference in a formula and its corresponding location in a worksheet identified?

A.    Arrows pointing from the formula to the location

B.     Cell reference and cell location are circled

C.     Cell reference and cell location are outlined in matching colors

D.    Lines connect from the formula to the location

Answer: C

69. What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

A.    Copy method from Shortcut Menu

B.     Copy using the Fill Handle

C.     Copy from the Home Ribbon

D.    Copy using the Quick Access Toolbar

Answer: B

70. Which option button enables a user to fill cells following a fill operation?

A.    AutoCorrect

B.     Insert

C.     Paste

D.    Auto Fill

Answer: D

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati