MS Excel Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key Clicking on the formula bar Pressing the Tab key Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Reference tabs Location tabs Position tabs Sheet tabs Reference tabs Location tabs Position tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula 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 Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy then select (new book) from To Book list and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Delete the column from the worksheet Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Delete the column from the worksheet Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS