MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals Select Format > Money from the menu None of the listed here Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals Select Format > Money from the menu None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Solver All of above Scenario Manager Goal seek Solver All of above Scenario Manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
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 How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F8 F9 F11 F10 F8 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS