MS Excel Which is used to perform what if analysis? Goal seek Scenario Manager Solver All of above Goal seek Scenario Manager Solver All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None 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 ( ) ROUND ( ) Div ( ) MOD ( ) FACT ( ) ROUND ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Wrap Text in Format > Cells Justify in Edit > Cells Text Wrapping in Format > Cells All of above Wrap Text in Format > Cells Justify in Edit > Cells Text Wrapping in Format > Cells All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS