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 then go to Cells then on Alignment tab click Transpose check box and click OK 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? * $ % & * $ % & ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Date () Now () Today () Time() Date () Now () Today () Time() ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation 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 addition and subtraction in a formula When you use multiplication, division, or exponentiation 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 addition and subtraction in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS