MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP
MS Excel The first cell in EXCEL worksheet is labeled as Aa AA A0 A1 Aa AA A0 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? 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 Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP