Excel Chapter 3 Review

You can use the fill handle to ____.

• Copy a cell
• Copy a range 
• create a series of numbers
• all of the above

When you use the _____ command, the item is copied to the Office Clipboard but is not removed from the worksheet until you click the Paste button

• Cut
• Copy special
• Paste
• Any of the above

To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _________. 

• Currency Dollar Sign
• Fixed Dollar Sign
• Floating Dollar sign

When excel automatically sets the width of a column based on the widest entry in the column, it is called _______.  

• Custom Fit
• Best Fit
• Choice Fit

When you copy a formula with a relative cell references down a row, 

• The column references change in the formula 
• The row references change in the formula
• The cell reference of the formula remains the same

When smart tags is on, Excel places a small _______ in a cell to indicate a smart tag is available.

• Black Triangle
• Black Square
• Black Circle

You can rotate the text counterclockwise by entering a number between 1* and 180* on the alignment sheet in the Format Cells dialog box.

• True 
• False

If you drag the fill handle to the left or up, Excel will decrement the series.

• True
• False

The move and copy command accomplish the same task.

• True
• False

The IF function is useful when you want to assign a value to a cell based on a logical test.

• True
• False