MS Excel Which function is not available in the Consolidate dialog box ? Max Pmt Average Sum Max Pmt Average Sum 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 Copy the cells in row, select the same number of cells in row and paste 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 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 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 You can use the format painter multiple times before you turn it off by 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 Double clicking the format painter button Pressing the Alt key and clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Choose None on Border tab of Format cells None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both Choose None on Border tab of Format cells None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both 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 An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS