MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by 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 Pressing the Ctrl key while dragging over the desired cells 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 Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Constraints Input cells Target cell Changing cells Constraints Input cells Target cell Changing cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Location tabs Reference tabs Position tabs Sheet tabs Location tabs Reference tabs Position tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Formula bar Vertical scroll bar Horizontal scroll bar Standard toolbar Formula bar Vertical scroll bar Horizontal scroll bar Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS