MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ & % * $ & % * ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar Pressing any arrow key on the keyboard 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 The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Double click the cell Press the Alt key Press the F2 key Click the formula bar Double click the cell Press the Alt key Press the F2 key ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the edit comment command on the insert menu Click the display comment command on the window menu Position the mouse pointer over the cell Click the comment command on the view menu Click the edit comment command on the insert menu Click the display comment command on the window menu Position the mouse pointer over the cell Click the comment command on the view menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS