MS Excel Rounding errors can occur When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can convert existing excel worksheet data an charts to an HTML document by using FTP wizard Intranet wizard Internet assistant wizard Import wizard FTP wizard Intranet wizard Internet assistant wizard Import wizard ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Click the formula bar Press the Alt key Double click the cell Press the F2 key Click the formula bar Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS