MS Excel To copy cell contents using drag and drop press the Shift key End key Esc key Ctrl key Shift key End key Esc key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? All of above Validation Formats Formulas All of above Validation Formats Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Font format All of above Number format Border format Font format All of above Number format Border format ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS