MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed 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 a way to complete a cell entry? Pressing any arrow key on the keyboard Pressing enter Pressing spacebar Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard Pressing enter Pressing spacebar Clicking the Enter button on the Formula bar 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 Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Complex Formulas Smart Formula Standard Formulas Array formula Complex Formulas Smart Formula Standard Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Add SQRT Divide Subtract Add SQRT Divide Subtract ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Select Data > Delete Record from the menu Click the Delete button on the Standard toolbar Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Select Data > Delete Record from the menu Click the Delete button on the Standard toolbar ANSWER DOWNLOAD EXAMIANS APP