To write a formula, we first need to select the proper formula for
this situation.
If we do not know the exact formula that is needed,
we can find a series of options on the formula bar.
If we open the Lookup and Reference bar,
we get a series of formulas that help us reference data.
When we hold our mouse over a formula,
Excel will give us a short description of that formula.
Excel has hundreds of functions that can be combined to do countless operations.
Even the most advanced Excel user is constantly learning new formulas and
new tricks.
Excel will assist you in writing formulas, but providing hints regarding
the structure of the formula that you selected, such as showing required inputs.
Excel formulas have both mandatory and optional fields.
The optional fields will be shown encompassed by brackets.
If you are unsure about the formula you are using,
or how to construct it, you can use the fx button which will walk you through
the construction of that specific formula.
Each formula has a unique logic that has to be followed in order for
the formula to calculate correctly.
Excel will prompt you if all fields are not provided,
or if fields are provided incorrectly.
For the third exercise, we will be looking into how Excel can help you
construct a formula, by providing various prompts.