MS Excel Which function is not available in the Consolidate dialog box ? Average Sum Max Pmt Average Sum Max Pmt 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 adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.8 5430 5436.80 6.8 5436.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Format > window View > window > split Window > split View > split Format > window View > window > split Window > split View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Column numbers and row letters Cell names Column letters and row numbers Cell locator coordinates Column numbers and row letters Cell names Column letters and row numbers ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS