MS Excel Concatenation of text can be done using Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check 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 delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check 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 delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 1024 32767 65535 256 1024 32767 65535 256 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ % * & $ % * ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Description Aditibility Efficiency Clarity Description Aditibility Efficiency Clarity ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS