MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to 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 View different rows and columns edit the contents of a cell Split a worksheet into two panes ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Input cells Target cell Changing cells Constraints Input cells Target cell Changing cells Constraints ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Max Average Sum Pmt Max Average Sum ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS