MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Cancel and Enter buttons appear in the: Title bar Sheet tabs Menu bar Formula bar Title bar Sheet tabs Menu bar Formula bar 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 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 You have to retype everything and manually add the dollar signs, commas, and decimals ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Hold titles command on the edit menu Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of 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 When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS