MS Excel Text formulas: Concatenate and manipulate text 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Number Character Label Date/Time Number Character Label Date/Time ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Goal seek Percentage Divide Square Goal seek Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 $A$1 !A!1 #a#1 A1 $A$1 !A!1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS