MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ & * % $ & * % 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
MS Excel Which button do you click to add up a series of numbers? The Formula button The quicktotal button The autosum button The total button The Formula button The quicktotal button The autosum button The total button ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A type of chart A division of results A collection of related data A cell reference A type of chart A division of results A collection of related data A cell reference ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move of Copy then choose (Move to end) and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK None of the listed here From Edit menu choose Move of Copy then choose (Move to end) and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK None of the listed here ANSWER DOWNLOAD EXAMIANS APP