MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Pmt Max Average Sum Pmt Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1048576 256 1024 65535 1048576 256 1024 65535 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 Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box All of above 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 key do you press to check spelling? F7 F9 F5 F3 F7 F9 F5 F3 ANSWER DOWNLOAD EXAMIANS APP