MS Excel Rounding errors can occur 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 When you use multiplication, division, or exponentiation in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Goal seek Percentage Divide Square Goal seek Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can convert existing excel worksheet data an charts to an HTML document by using Intranet wizard Import wizard FTP wizard Internet assistant wizard Intranet wizard Import wizard FTP wizard Internet assistant wizard 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 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 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 The Paste Special command lets you copy and paste: Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS