MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column numbers and row letters Column latters and row numbers Cell names Cell locator coordinates Column numbers and row letters Column latters and row numbers Cell names Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formats Formulas All of above Validation Formats Formulas All of above Validation ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A collection of related data A cell reference A division of results A type of chart A collection of related data A cell reference A division of results A type of chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > split View > window > split Window > split Review > window View > split View > window > split Window > split Review > window ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS