MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Border format All of above Number format Font format Border format All of above Number format Font format ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu All of above Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Delete the column from the worksheet Select Data > Delete Record from the menu 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 Delete the column from the worksheet Select Data > Delete Record from the menu 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS