MS Excel Which is used to perform what if analysis? Scenario Manager All of above Solver Goal seek Scenario Manager All of above Solver Goal seek 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 All of above Use =if() function to format the required numbers red 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 All of above Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Subtract Divide Add SQRT Subtract Divide Add ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel displays the current cell address in the ___ Name Box Title Bar Status Bar Formula Bar Name Box Title Bar Status Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS