MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by None of these Double clicking the cell to edit it in place Clicking the formula button Selecting Edit > Edit cell from the menu None of these Double clicking the cell to edit it in place Clicking the formula button Selecting Edit > Edit cell from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When no sheet is selected One sheet is selected When many sheets are selected None of the listed here When no sheet is selected One sheet is selected When many sheets are selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above 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 in formula too You can search for bold and replace with italics You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search in formula too You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value ANSWER DOWNLOAD EXAMIANS APP