MS Excel Which of following is Not one of Excel's what-if function? Solver Auto Outline Scenario manager Goal seek Solver Auto Outline Scenario manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Formula Bar Title Bar Menu Bar Standard Tool Bar Formula Bar Title Bar 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 The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B Is defined by a bold border around the cell Receives the data the user enters It is the formula bar Only A and B Is defined by a bold border around the cell Receives the data the user enters It is the formula bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS