MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Apply double underline for the active cell None of the listed here Fill down in the selection Open the font dialog box Apply double underline for the active cell None of the listed here Fill down in the selection Open the font dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key Ctrl key End key Shift key Esc key Ctrl key End key Shift key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS