MS Excel Which elements of worksheet can be protected from accidental modification Contents Scenarios All of the listed here Objects Contents Scenarios All of the listed here Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur Because excel uses hidden decimal places in computation 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 When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation 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 When you use addition and subtraction in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press the Alt key None Press Tab Press Enter Press the Alt key None Press Tab Press Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the status bar Shows the location of the previously active cell Appears below the menu bar Appears to the left of the formula bar Appears below the status bar Shows the location of the previously active cell Appears below the menu bar Appears to the left of the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 $A$1 !A!1 A1 #a#1 $A$1 !A!1 A1 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