MS Excel In help menu of Excel, which of the following tabs are found? Index tab Contents tab Answer Wizard tab All of these Index tab Contents tab Answer Wizard tab All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to None of above Remove the cell contents of selected cells Right align the content of cell Fill the selection with active cells to the right None of above Remove the cell contents of selected cells Right align the content of cell Fill the selection with active cells to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Square Divide Percentage Goal seek Square Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? 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 None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS