MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ & * % $ & * % ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key End key Ctrl key Shift key Esc key End key Ctrl key Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet 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 Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The organization of individual values with a chart’s data series A horizontal axis A chart plot area The data range that supply chart data The organization of individual values with a chart’s data series A horizontal axis A chart plot area The data range that supply chart data ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS