MS Excel When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document must contain a hyperlink The word document contains a reference to the original source application The word document contains a copy of the actual data The word document cannot be edit The word document must contain a hyperlink The word document contains a reference to the original source application The word document contains a copy of the actual data 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
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Changing cells Target cell Constraints Input cells Changing cells Target cell Constraints Input cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? * & $ % * & $ % ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Both None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells Both None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells ANSWER DOWNLOAD EXAMIANS APP