MS Excel
To create a formula, you can use:

Value and cell references
Values or cell references although not both at the same time
Values but not cell references
Cell references but not values

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Replace cell references
Return ASCII values of characters
Show formula error value
Concatenate and manipulate text

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you select an entire column?

Hold down the Ctrl key as you click anywhere in the column
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Select Edit > Select > Column from the menu

ANSWER DOWNLOAD EXAMIANS APP