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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Smart Formula Standard Formulas Complex Formulas Array formula Smart Formula Standard Formulas Complex Formulas Array formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS