MS Excel Which of the following is an absolute cell reference? !A!1 A1 #a#1 $A$1 !A!1 A1 #a#1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Target cell Constraints Changing cells Input cells Target cell Constraints Changing cells Input cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments can be added to cells using Insert > Comments File > Comments View > Comments Edit > Comments Insert > Comments File > Comments View > Comments Edit > Comments ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS