MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells 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 choose Merge and Center check box From Format Cells dialog box click on Merge Cells 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 choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells Justify in Edit > Cells All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells 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 in column then choose Paste Special, then click Transpose and OK 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document None of the listed here 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 Alt 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 Shift 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 the Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Workbooks Group of Columns Group of Rows Group of Worksheets Group of Workbooks Group of Columns Group of Rows Group of Worksheets ANSWER DOWNLOAD EXAMIANS APP