MS Excel How can you delete a record? Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Delete the column from the worksheet Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Delete the column from the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? 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 add more than one condition to check 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 set condition to look for Bold and apply Italics on them 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 How do you rearrange the data in ascending or descending order? Data, Sort Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which key do you press to check spelling? F9 F3 F7 F5 F9 F3 F7 F5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP