MS Excel Which is used to perform what if analysis? All of above Scenario Manager Solver Goal seek All of above Scenario Manager Solver Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address 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 Goal seek Square Percentage Divide Goal seek Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel The chart wizard term data series refers to A set of values you plot in a chart A chart legend A data label A collection of chart data markers A set of values you plot in a chart A chart legend A data label A collection of chart data markers ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Java Visual C++ Visual Basic C Java Visual C++ Visual Basic C ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP