MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from From Line style tool in Drawing toolbar From Border tool in Formatting toolbar You can not set Page Border in Excel From Border tab in Farmat cells dialog box From Line style tool in Drawing toolbar From Border tool in Formatting toolbar You can not set Page Border in Excel From Border tab in Farmat cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Review > window View > window > split View > split Window > split Review > window View > window > split View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Efficiency Description Aditibility Clarity Efficiency Description Aditibility Clarity ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS