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 Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of above None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Text Wrapping in Format > Cells Justify in Edit > Cells Wrap Text in Format > Cells All of above Text Wrapping in Format > Cells Justify in Edit > Cells Wrap Text in Format > Cells All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Standard toolbar Horizontal scroll bar Formula bar Vertical scroll bar Standard toolbar Horizontal scroll bar Formula bar Vertical scroll bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None Click Gridline tool on Forms toolbar ANSWER DOWNLOAD EXAMIANS APP