MS Excel You can edit a cell by Double clicking the cell to edit it in place None of these Selecting Edit > Edit cell from the menu Clicking the formula button Double clicking the cell to edit it in place None of these Selecting Edit > Edit cell from the menu Clicking the formula button 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 Divide Percentage Goal seek Square Divide Percentage Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + C Ctrl + Enter Ctrl + Page Up Ctrl + Space Bar Ctrl + C Ctrl + Enter Ctrl + Page Up ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a 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 Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two View > window > split Format > window View > split Window > split View > window > split Format > window View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references ANSWER DOWNLOAD EXAMIANS APP