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