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 Which elements of worksheet can be protected from accidental modification Contents Objects All of the listed here Scenarios Contents Objects All of the listed here Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you print three copies of a workbook? Select File > Properties form the menu and type 3 in the Copies to print text box Select File > Print from the menu and type 3 in the Number of copies text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 Select File > Properties form the menu and type 3 in the Copies to print text box Select File > Print from the menu and type 3 in the Number of copies text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Growth Time Linear Autofill Growth Time Linear Autofill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Divide Goal seek Percentage Square Divide Goal seek Percentage ANSWER DOWNLOAD EXAMIANS APP