MS Excel You can select a single range of cells by 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 Dragging over the desired cells Pressing the Shift key and an arrow key 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 Dragging over the desired 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 menu option can be used to split windows into two View > split View > window > split Format > window Window > split View > split View > window > split Format > window Window > split ANSWER DOWNLOAD EXAMIANS APP
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 sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column letters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers Cell names Column numbers and row letters Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS