MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Add Divide SQRT Subtract Add Divide SQRT ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Double clicking the format painter button Pressing the Alt key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button Pressing the Alt key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Ctrl key and clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS