MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To activate the previous cell in a pre-selected range, press The Tab key The Enter key None of these The Alt key The Tab key The Enter key None of these The Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing the Esc key Pressing an arrow key Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP
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 Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ % * & $ % * ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS