lesson 13

A volatile function stays the same every time you open the workbook

False

Formula AutoComplete does not work with range names

False

It's a practice to begin a range name with a number.

False

Range names are case sensitive.

False

Spaces are allowed in range names

False

You can not give a single cell a range name

False

You must enter the arguments for the NOW function within the parenthesis.

False

A range name can be up to 255 characters long.

True

After naming a range, you can use that name in formulas and within function arguments in place of cell addresses.

True

Do not begin a range name with a number.

True

Use a range to reference a cell or range of cells by name rather than by cell address(es).

True

We learned 3 different ways to name ranges - Using the Name Box, right-clicking and choosing Define Name, and going to the Formulas tab on the ribbon.

True

When you need to include a date and time that automatically updates on the worksheet, insert the NOW function.

True

You can also define a range by right-clicking the selected range and choosing Define Range to begin the naming process.

True

You can define a range name using the Name Box at the left end of the formula bar.

True

You can not change the format of the displayed NOW function results.

True

You can not use the fill handle to fill in contiguous cells with formulas using range names because range names use absolute cell references ($A$1).

True

You can use the Name Manager dialog box to edit or delete named ranges.

True

You should use short descriptive names when naming ranges because they are easier to read and remember.

True

it's a good idea to sort your data before you assign range names.

True