MS Excel Which of the following action removes a sheet from workbook? Both of above Select the sheet then choose Format > Sheet > Hide None of above Select the sheet, then choose Edit > Delete Sheet Both of above Select the sheet then choose Format > Sheet > Hide None of above Select the sheet, then choose Edit > Delete Sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed 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 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 Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column latters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column latters and row numbers Column numbers and row letters Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS