MS Excel Which of the following option is not available in paste Special dialog box ? Divide Subtract SQRT Add Divide Subtract SQRT Add ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Border Copy handle Insert handle Fill handle Border Copy handle Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Pressing the Alt key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button Pressing the Alt key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS