MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press Tab Press Enter Press the Alt key None Press Tab Press Enter Press the Alt key None ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually None of these Client Server Source None of these Client Server Source ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Divide Percentage Square Goal seek Divide Percentage Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data It can be modified You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data It can be modified ANSWER DOWNLOAD EXAMIANS APP