MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Percentage Goal seek Divide Square Percentage Goal seek Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using Applying styles Auto formatting All of the listed here Changing fonts Applying styles Auto formatting All of the listed here Changing fonts ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? 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 To add shading or color to a cell range To insert a background ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Orientation Paper Layout Margin Orientation Paper Layout Margin ANSWER DOWNLOAD EXAMIANS APP