MS Excel A circular reference is Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The total button The autosum button The quicktotal button The Formula button The total button The autosum button The quicktotal button The Formula button ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when None of the listed here When many sheets are selected When no sheet is selected One sheet is selected None of the listed here When many sheets are selected When no sheet is selected One sheet is selected 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 add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions 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 add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. AutoFill Auto correct Auto format Auto sum AutoFill Auto correct Auto format Auto sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Border Insert handle Copy handle Fill handle Border Insert handle Copy handle ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS