MS Excel Concatenation of text can be done using Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) 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 search for bold and replace with italics You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F9 F8 F10 F11 F9 F8 F10 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Add Subtract Divide SQRT Add Subtract Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To select a distribution of figures To add borders To add shading or color to a cell range To insert a background To select a distribution of figures To add borders To add shading or color to a cell range To insert a background ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS