MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Press the Alt key Press the F2 key Double click the cell Click the formula bar Press the Alt key Press the F2 key Double click the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Border format Number format Font format All of above Border format Number format Font format All of above ANSWER DOWNLOAD EXAMIANS APP
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 in row, select the same number of cells in row and paste 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 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 row, select the same number of cells in row and paste 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 Which of the following action removes a sheet from workbook? Select the sheet, then choose Edit > Delete Sheet None of above Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above Select the sheet then choose Format > Sheet > Hide Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Doctor's symbol (Big Plus) None of the listed here Mouse pointer with anchor at the tip Small thin plus icon Doctor's symbol (Big Plus) None of the listed here Mouse pointer with anchor at the tip Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS