MS Excel How can you remove borders applied in cells ? Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Objects All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? All of above Scenario Manager Goal seek Solver All of above Scenario Manager Goal seek Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? 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 Click the Delete button on the Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP