MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Target cell Changing cells Constraints Input cells Target cell Changing cells Constraints Input cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column latters and row numbers Cell names Cell locator coordinates Column numbers and row letters Column latters and row numbers Cell names Cell locator coordinates Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Both Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None Both Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from From Border tab in Farmat cells dialog box From Border tool in Formatting toolbar You can not set Page Border in Excel From Line style tool in Drawing toolbar From Border tab in Farmat cells dialog box From Border tool in Formatting toolbar You can not set Page Border in Excel From Line style tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS