MS Excel
How do you rearrange the data in ascending or descending order?

Data Subtotals
Data, Form
Data, Sort
Data, Table

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you select an entire column?

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

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

ANSWER DOWNLOAD EXAMIANS APP