MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Square Percentage Goal seek Divide Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Average Sum Max Pmt Average Sum Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Position tabs Reference tabs Location tabs Sheet tabs Position tabs Reference tabs Location tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different rows and columns edit the contents of a cell Split a worksheet into two panes View different worksheets Edit the contents of a cell View different rows and columns edit the contents of a cell Split a worksheet into two panes View different worksheets Edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS