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 From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of workbook currently working on Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of workbook currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right None of above Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press Esc Press the Erase key Press the Edit Formula button Press the Enter button Press Esc Press the Erase key Press the Edit Formula button Press the Enter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS