MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied 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 Percentage Divide Square Goal seek Percentage Divide Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the bottom left corner Towards the top left corner Towards the top right corner Towards the bottom right corner Towards the bottom left corner Towards the top left corner Towards the top right corner Towards the bottom right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? " (quote) = (equal) _ (underscore) ' (apostrophe) " (quote) = (equal) _ (underscore) ' (apostrophe) ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the End key Esc key Shift key Ctrl key End key Esc key Shift key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS