MS Excel You can select a single range of cells by Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
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 B7:B9 indicates: None of these Cells B7 and cell B9 only Cell B8 only Cells B7 through B9 None of these Cells B7 and cell B9 only Cell B8 only Cells B7 through B9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Constraints Input cells Changing cells Target cell Constraints Input cells Changing cells Target cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Layout Margin Orientation Paper Layout Margin Orientation Paper ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS