MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F8 F9 F11 F10 F8 F9 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None of these Server Source Client None of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box O 5 10 1 O 5 10 1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To add borders To select a distribution of figures To insert a background To add shading or color to a cell range To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar 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
EXAMIANS