MS Excel You can edit a cell by Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Objects All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of workbook currently working on Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP