MS Excel Which of the following is not a way to complete a cell entry? Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard Pressing spacebar Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard Pressing spacebar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Select the cell you want to place the formula into 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 Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into 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 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? Divide Goal seek Square Percentage Divide Goal seek Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) Small thin plus icon None of the listed here Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) Small thin plus icon None of the listed here ANSWER DOWNLOAD EXAMIANS APP