MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The enter button The cancel button The edit formula button All of these The enter button The cancel button The edit formula button All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 A1 ANSWER DOWNLOAD EXAMIANS APP
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 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 Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Work sheet Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS