MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Percentage Goal seek Divide Square Percentage Goal seek Divide Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation in a formula When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation When you use multiplication, division, or exponentiation in a formula When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Files created with Lotus 1-2-3 have an extension Doc XLS WK1 123 Doc XLS WK1 123 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Text Wrapping in Format > Cells All of above Justify in Edit > Cells Wrap Text in Format > Cells Text Wrapping in Format > Cells All of above Justify in Edit > Cells Wrap Text in Format > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in column then choose Paste Special, then click Transpose and 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK 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
EXAMIANS