MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear Delete Clear All Clear Contents Delete Clear Delete Clear All Clear Contents Delete 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 All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Referencing Updating Functioning Accessing Referencing Updating Functioning Accessing ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS