MS Excel The Paste Special command lets you copy and paste: Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 256 1024 32767 65535 256 1024 32767 65535 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both Choose None on Border tab of Format cells None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both Choose None on Border tab of Format cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on column right border on column header Double clicking on the column name on column header Double click on the cell pointer in worksheet Double clicking on the column left border of column header Double clicking on column right border on column header Double clicking on the column name on column header Double click on the cell pointer in worksheet Double clicking on the column left border of column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Average Max Pmt Sum Average Max ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS