MS Excel Which is used to perform what if analysis? Solver Goal seek All of above Scenario Manager Solver Goal seek All of above Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 Excel StarCalc VisiCalc Lotus 1-2-3 Excel StarCalc ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Objects Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here 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? None of the listed here Click the Currency Style button on the formatting toolbar Select Format > Money from the menu You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Click the Currency Style button on the formatting toolbar Select Format > Money from the menu You have to retype everything and manually add the dollar signs, commas, and decimals ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is no suitable abbreviation for the text There is not time to format the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells There is no suitable abbreviation for the text There is not time to format the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells ANSWER DOWNLOAD EXAMIANS APP