MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R 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 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 Unfreeze panes command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Objects Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates you that you can make selection? None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Press the Alt key Pressing the F2 key Double clicking the cell Clicking the formula bar Press the Alt key Pressing the F2 key Double clicking the cell Clicking the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS