MS Excel How can you delete a record? Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Delete the column from the worksheet 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 Select Data > Delete Record from the menu Delete the column from the worksheet Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button 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 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 The Name box on to the left of formula bar None of the listed here Shows the name of cell or range currently working on Shows the name of worksheet currently working on Shows the name of workbook currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of worksheet currently working on Shows the name of workbook currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both None of the listed here You can Find and Replace within the sheet or workbook Excel does not have option to match case for find Both None of the listed here You can Find and Replace within the sheet or workbook Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7+14 =B7*B1 10+50 =10+50 =B7+14 =B7*B1 10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 256 32767 65535 1024 256 32767 65535 1024 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS