Excel 2010 Test Questions -13

61. In Excel 2010, which of the following can you use to erase or clear a cell or range of cells?

A.    Cell Styles Button, Shortcut menu, and Fill Handle

B.     Quick Access Toolbar, Shortcut menu, and Cell Styles button

C.     Fill Handle, Delete Key, and Quick Access Toolbar

D.    Cell Styles Button, Shortcut menu, and Undo button

Answer: A

62. What is a prewritten formula that is built into Excel 2010 called?

A.    Utility

B.     Procedure

C.     Function

D.    Statement

Answer: C

63. Where can you find the Insert Function button in Excel 2010?

A.    Quick Access Toolbar

B.     Formula bar

C.     Status bar

D.    Shortcut menu

Answer: B

64. Which of the following always begins with an equal sign (=) and performs calculations or other actions using the data in a worksheet?

A.    Formula

B.     Array

C.     Range

D.    Series

Answer: A

65. How often does Excel 2010 automatically recalculate formulas in a worksheet?

A.    Every 5 minutes

B.     Each time you click on a cell

C.     Each time you enter a value into a cell

D.    Each time the worksheet is opened or closed

Answer: C

If You Enjoyed This, Take 5 Seconds To Share It

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