MS Excel Text formulas: Replace cell references Concatenate and manipulate text Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text Return ASCII values of characters Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Documentation should include All of these Information on the purpose of the workbook Destination and users of the output data Source of input data All of these Information on the purpose of the workbook Destination and users of the output data Source of input data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Divide Add SQRT Subtract Divide Add SQRT 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 decide whether to look for the whole word or not You can search for bold and replace with italics You can search in formula too You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search in formula too ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS