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 The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? none of above 8 3 255 none of above 8 3 255 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Objects Scenarios All of the listed here Contents Objects Scenarios All of the listed here Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Input cells Target cell Constraints Changing cells Input cells Target cell Constraints Changing cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Applies a boarder around the selected cells Automatically adds range of cell values Extends a sequential series of data All of the listed here Applies a boarder around the selected cells Automatically adds range of cell values Extends a sequential series of data All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you want to insert a blank embedded excel object in a word document you can Click the create worksheet button on the formatting toolbar Click the import excel command on the file menu Click the office links button on the standard toolbar Click the object command on the insert menu Click the create worksheet button on the formatting toolbar Click the import excel command on the file menu Click the office links button on the standard toolbar Click the object command on the insert menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS