MS Excel Which of the following is an absolute cell reference? A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Enter assumptions data Format cells containing numbers Copy a range of cells Create and edit formula containing functions Enter assumptions data Format cells containing numbers Copy a range of cells Create and edit formula containing functions ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Contents Objects Scenarios All of the listed here Contents Objects Scenarios All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie All of the listed here Line Area Pie All of the listed here Line Area ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS