MS Excel Which of the following is not information you can specify using the solver? Input cells Target cell Changing cells Constraints Input cells Target cell Changing cells Constraints 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 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 Text formulas: Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Border format Font format All of above Number format Border format Font format All of above Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? ' (apostrophe) " (quote) _ (underscore) = (equal) ' (apostrophe) " (quote) _ (underscore) = (equal) ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS