MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values or cell references although not both at the same time Value and cell references Cell references but not values Values but not cell references Values or cell references although not both at the same time Value and cell references Cell references but not values Values but not cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To add shading or color to a cell range To insert a background To add borders To select a distribution of figures To add shading or color to a cell range To insert a background To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box 5 O 1 10 5 O 1 10 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS