MS Excel Which of the following is not true regarding Conditional Formatting? 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 add more than one condition to check 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 apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort Data, Form Data, Table 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? Copy handle Fill handle Border Insert handle Copy handle Fill handle Border Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. File Insert View Tools File Insert View Tools ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS