MS Excel Which is used to perform what if analysis? Goal seek All of above Scenario Manager Solver Goal seek All of above Scenario Manager Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? _ (underscore) ' (apostrophe) = (equal) " (quote) _ (underscore) ' (apostrophe) = (equal) " (quote) ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? All of above Formulas Formats Validation All of above Formulas Formats Validation ANSWER DOWNLOAD EXAMIANS APP