MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F 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 the Erase key Press Esc Press the Edit Formula button Press the Enter button Press the Erase key Press Esc Press the Edit Formula button Press the Enter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS