MS Excel The Paste Special command lets you copy and paste: Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments put in cells are called Soft Tip Smart Tip Web Tip Cell Tip Soft Tip Smart Tip Web Tip Cell Tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column latters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column latters and row numbers Column numbers and row letters Cell locator coordinates Cell names ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS