To rename the active worksheet use one of these two methods:
Method 1
1. On the format menu point to Sheet then click Rename. The sheet tab name will be highlighted (edit mode).
2. Type the new name, then click anywhere outside the tab name.
Method 2
Simply double-click the sheet tab name, to get into edit mode, and then [...]
The INDIRECT function returns a reference specified by a text string, evaluates that reference and displays its contents. The function is useful when you want a cell reference in a formula to be variable, without the need to change the formula every time.
Syntax
INDIRECT(ref_text,a1)
ref_text: a text that contains a cell reference.
a1: a logical value that [...]
The Conditional sum wizard helps you create complex formulas to sum values in a column based on certain criteria. The wizard is part of Excel Add-ins. You must load it first before it can show up in the Tools menu. See then bottom of this post if you want to know how to load the [...]
The RANK function returns the rank of a number, i.e. its position within a list of numbers. It is based on the value of a number, relative to the other numbers in the list.
The list evaluated by the rank doesn’t have to be sorted, but to get the idea of how items are ranked imagine [...]
#NAME? error occurs when Excel doesn’t recognize text in a formula.
Possible causes and solutions
1. Referring to a defined name that does not exist. On the Insert menu, point to Name, and then click Define.
If the name is not listed, add the name by using the Define command.
If the name is misspelled, add the correct name [...]
