MS Excel When you copy a formula 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 Excel doesn’t adjust relative cell references 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 Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek Solver All of above Scenario Manager Goal seek Solver All of above Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel displays the current cell address in the ___ Formula Bar Title Bar Status Bar Name Box Formula Bar Title Bar Status Bar Name Box ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document must contain a hyperlink The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Manipulate values Manipulate labels Return a formula result Use the addition operator Manipulate values Manipulate labels Return a formula result Use the addition operator ANSWER DOWNLOAD EXAMIANS APP