MS Excel Which of the following option is not available in paste Special dialog box ? Divide SQRT Subtract Add Divide SQRT Subtract Add ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Protection Password Write Reservation Password Read-only Recommended Any of the above Protection Password Write Reservation Password Read-only Recommended Any of the above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS