MS Excel Which of following is Not one of Excel's what-if function? Auto Outline Solver Scenario manager Goal seek Auto Outline Solver Scenario manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu 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 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 Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The enter button The cancel button The edit formula button All of these The enter button The cancel button The edit formula button All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Java C Visual C++ Visual Basic Java C Visual C++ Visual Basic ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP