MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Cell comments Formatting options Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Position tabs Location tabs Reference tabs Sheet tabs Position tabs Location tabs Reference tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ * % & $ * % ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 none of above 3 255 8 none of above 3 255 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Contents All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios ANSWER DOWNLOAD EXAMIANS APP