MS Excel
When you copy a formula

Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesn’t adjust relative cell references
Excel erases the original copy of the formula

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box choose Merge and Center check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box click on Merge Cells check box
Click on Merge and Center tool on formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

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

ANSWER DOWNLOAD EXAMIANS APP