MS Excel The auto calculate feature A and C 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 Can only add values in a range of cells A and C 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 Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Add Divide SQRT Subtract Add Divide SQRT ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? None of the listed here Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation None of the listed here Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Work sheet Chart sheet Data sheet Macro sheet Work sheet Chart sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu ANSWER DOWNLOAD EXAMIANS APP