MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Sort Data, Form 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 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 Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Clicking on the formula bar Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) 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 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
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Status Bar None Tool Bar Formula Bar Status Bar None Tool Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP