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 Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Edit the hyperlink Use the word menu bar and toolbars Use the excel menu bar and toolbars inside the word application Edit the data in a excel source application Edit the hyperlink Use the word menu bar and toolbars Use the excel menu bar and toolbars inside the word application Edit the data in a excel source application ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Solver Scenario manager Auto Outline Goal seek Solver Scenario manager Auto Outline Goal seek 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? Select Format > Money from the menu You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Click the Currency Style button on the formatting toolbar Select Format > Money from the menu You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Click the Currency Style button on the formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.80 5430 5436.8 6.8 5436.80 5430 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Cell comments Formatting options The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Cell comments Formatting options ANSWER DOWNLOAD EXAMIANS APP