MS Excel All worksheet formula Manipulate values Use the addition operator Return a formula result Manipulate labels Manipulate values Use the addition operator Return a formula result Manipulate labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Divide Percentage Goal seek Square Divide Percentage Goal seek Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data 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 Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Title Bar Formula Bar Standard Tool Bar Menu Bar Title Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS