MS Excel
The Paste Special command lets you copy and paste:

The resulting values of a formula instead of the actual formula
Formatting options
Multiply the selection by a copied value
Cell comments

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can select a single range of cells by

Dragging over the desired cells
Pressing the Ctrl key while dragging over the desired cells
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Shift key and an arrow key

ANSWER DOWNLOAD EXAMIANS APP