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? You have to retype everything and manually add the dollar signs, commas, and decimals Click the Currency Style button on the formatting toolbar Select Format > Money from the menu None of the listed here You have to retype everything and manually add the dollar signs, commas, and decimals Click the Currency Style button on the formatting toolbar Select Format > Money from the menu None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formats Formulas Validation All of above Formats Formulas Validation All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Cell value Both None Formula Cell value Both None Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Client None of these Source Server Client None of these Source ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS