MS Excel Which of the following Excel screen components can NOT be turned on or off ? Tool Bar Status Bar None Formula Bar Tool Bar Status Bar None Formula Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value? 0.57 350 Serial Number 50771 May 10, 2001 0.57 350 Serial Number 50771 May 10, 2001 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula 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 Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula 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 ANSWER DOWNLOAD EXAMIANS APP