MS Excel When you copy a 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 Excel edits cell references in the newly copied formula 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 Shift + Home Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home Press Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel worksheet cells work very similarly to what common element of the windows graphical user interface Text boxes List boxes Option buttons Combo boxes Text boxes List boxes Option buttons Combo boxes ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The quicktotal button The total button The Formula button The autosum button The quicktotal button The total button The Formula button The autosum button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Goal seek Scenario manager Solver Auto Outline Goal seek Scenario manager Solver Auto Outline ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Status Bar Formula Bar None Tool Bar Status Bar Formula Bar None Tool Bar ANSWER DOWNLOAD EXAMIANS APP