MS Excel Which is used to perform what if analysis? Goal seek Scenario Manager All of above Solver Goal seek Scenario Manager All of above Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Contents Objects Scenarios All of the listed here Contents Objects Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the F2 key Click the formula bar Press the Alt key Double click the cell Press the F2 key Click the formula bar Press the Alt key Double click the cell 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 Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Square Percentage Divide Goal seek Square Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS