MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
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 apply Font, border and pattern formats that meets the specified conditions 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 set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Window > split View > split Review > window View > window > split Window > split View > split Review > window View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Both Formula None Cell value Both Formula None Cell value 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 Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS