MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions 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 status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 123 Xls Wk1 Xlw 123 Xls Wk1 Xlw ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? ROUND ( ) Div ( ) FACT ( ) MOD ( ) ROUND ( ) Div ( ) FACT ( ) MOD ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Validation Formulas Formats All of above Validation Formulas Formats All of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS