MS Excel When a row of data is to be converted into columns 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 then go to Cells then on Alignment tab click 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 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 then go to Cells then on Alignment tab click 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
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find None of the listed here Both You can Find and Replace within the sheet or workbook Excel does not have option to match case for find None of the listed here Both You can Find and Replace within the sheet or workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) 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 Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the Alt key Press the F2 key Click the formula bar Double click the cell Press the Alt key Press the F2 key Click the formula bar Double click the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 128 256 1024 16384 128 256 1024 16384 ANSWER DOWNLOAD EXAMIANS APP