MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? Div ( ) FACT ( ) MOD ( ) ROUND ( ) Div ( ) FACT ( ) MOD ( ) ROUND ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Cut and Paste Paste Special > Transpose Both of above None of above Cut and Paste Paste Special > Transpose Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column letters and row numbers Cell names Cell locator coordinates Column numbers and row letters Column letters and row numbers Cell names Cell locator coordinates Column numbers and row letters 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 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 None of the listed here 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 By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key None of the listed here 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS