MS Excel Which function is not available in the Consolidate dialog box ? Average Pmt Sum Max Average Pmt Sum Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text Return ASCII values of characters Show formula error value Replace cell references Concatenate and manipulate text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Growth Time Linear Autofill Growth Time Linear Autofill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Apply double underline for the active cell Open the font dialog box Fill down in the selection None of the listed here Apply double underline for the active cell Open the font dialog box Fill down in the selection None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box 5 10 O 1 5 10 O 1 ANSWER DOWNLOAD EXAMIANS APP