MS Excel Which command will you choose to convert a column of data into row? Both of above Cut and Paste Paste Special > Transpose None of above Both of above Cut and Paste Paste Special > Transpose None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual Basic Visual C++ C Java Visual Basic Visual C++ C Java ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the display comment command on the window menu Click the comment command on the view menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the display comment command on the window menu Click the comment command on the view menu Click the edit comment command on the insert menu Position the mouse pointer over the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS