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

Data, Table
Data Subtotals
Data, Sort
Data, Form

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Double click the Format Painter and then press Esc key in keyboard
Click on Remove Formatting tool on Standard Toolbar
From Edit menu choose Delete
From Edit menu choose Clear and then Formats

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
The Name box on to the left of formula bar

None of the listed here
Shows the name of cell or range currently working on
Shows the name of workbook currently working on
Shows the name of worksheet currently working on

ANSWER DOWNLOAD EXAMIANS APP