MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Freeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the display comment command on the window menu Click the comment command on the view menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the display comment command on the window menu Click the comment command on the view menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Double clicking the cell Pressing the F2 key Clicking the formula bar Press the Alt key Double clicking the cell Pressing the F2 key Clicking the formula bar Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can convert existing excel worksheet data an charts to an HTML document by using Internet assistant wizard FTP wizard Intranet wizard Import wizard Internet assistant wizard FTP wizard Intranet wizard Import wizard ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP