MS Excel The command Edit > Fill Across Worksheet is active only when When many sheets are selected One sheet is selected When no sheet is selected None of the listed here When many sheets are selected One sheet is selected When no sheet is selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Rows Group of Worksheets Group of Columns Group of Workbooks Group of Rows Group of Worksheets Group of Columns Group of Workbooks ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can copy data or formulas With buttons on the standard toolbars With the copy, paste and cut commands on the edit menu All of these With commands on the shortcut menu With buttons on the standard toolbars With the copy, paste and cut commands on the edit menu All of these With commands on the shortcut menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS