MS Excel Which elements of a worksheet can be protected from accidental modification? Objects All of the listed here Scenarios Contents Objects All of the listed here Scenarios Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt 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 None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Target cell Constraints Input cells Changing cells Target cell Constraints Input cells Changing cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS