MS Excel When you copy a 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 Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F9 F8 F10 F11 F9 F8 F10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek All of above Scenario Manager Solver Goal seek All of above Scenario Manager Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Hyperlinked placed in a word table Use the word menu bar and toolbars Linked Embedded Hyperlinked placed in a word table Use the word menu bar and toolbars Linked Embedded ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS