MS Excel The auto calculate feature A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear > Contents Edit > Delete All of the listed here Edit > Clear >All Edit > Clear > Contents Edit > Delete All of the listed here Edit > Clear >All ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Pressing an arrow key Pressing the Tab key All of these Clicking the cell Pressing an arrow key Pressing the Tab key All of these Clicking the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Scenarios Objects All of the listed here Contents Scenarios Objects All of the listed here Contents ANSWER DOWNLOAD EXAMIANS APP