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 can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F9 F10 F8 F11 F9 F10 F8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Values and formulas but not labels Labels and values but not formulas Labels, values, and formulas Formulas only Values and formulas but not labels Labels and values but not formulas Labels, values, and formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Replace cell references Concatenate and manipulate text Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP