Page 1 :
SESSION IN BRIEF, , , , What-If feature of Excel is to make better, faster and more accurate decisions based on data., What-If Analysis tools are: Data Tables , Scenario Manager and Goal Seek., A scenario is a set of input values that you can save in Excel and can substitute in a worksheet to, , perform What-If Analysis., The Goal Seek feature is a What-If analysis tool that allows you to find the input values needed to, , achieve a goal., , Solver is used for Advanced Goal Seek., Solver determines what values need to be in multiple input cells to achieve a desired result., , ANALYSE DATA USING SCENARIOS AND GOAL SEEK

Page 2 :
A. MULTIPLE CHOICE QUESTIONS, , i., , Which of the following tab has What-If Analysis feature?, b) Data c) Formulas, , , , a) Review, Which of the following feature is used to find the input value to achieve a goal?, a) Goal Seek b) Scenario c) Data Tables, , is used to copy a formula from one cell to another., , , , a) Copy the cell b) Cut the cell c) AutoFill Handle, , I)b 2)a 3)c, , , , B. THEORETICAL QUESTIONS — (SOLVED), , i, , A., , R, , =, , What is the use of What-If Analysis feature?, , What-If analysis is the process of changing the values in cells to see how those changes will affect, , the outcome of formulas on the worksheet., , It is useful in many situations while doing data analysis. For example —, - You can propose different budgets based on revenue., , You can predict the future values based on the given historical values., , What is a scenario?, , cenario is a set of input values that you can save in Excel and can substitute in, f Analysis. You can create and save different groups of values as scenarios on 4, hen switch between these scenarios to view the different results., , As a worksheet to, perform What-I, worksheet and t, , Write the formula to calculate the sum of the cell B3 in Sheet3 and cell B3 of Sheet4 in some, other sheet? i, , =SUM(Sheet3!B3, Sheet4!B3), , What is the use of AutoFill handle?, , AutoFill handle is used to copy the formula from one cell to rest of the cells.

Page 3 :
SESSION IN BRIEF :, Microsoft Excel provides the ability for cells in one worksheet to be linked to cells in other, , worksheets in the same or different workbook., Consolidating data from other workbooks or worksheets is referred to as linking or external, , reference., The worksheet that has the data is the source worksheet and the sheet that wants the data is the, , destination worksheet., A hyperlink is a coloured and underlined text or a coloured and underlined graphic that you click, , to open a file, a location in a file or a Web page on the Web., An absolute hyperlink is a hyperlink that contains the full address of the destination file or of the, , Web site., A relative hyperlink is a hyperlink that contains an address that is relative to the address of the, , destination file., , LINK DATA AND SPREADSHEETS

Page 4 :
A. MULTIPLE CHOICE QUESTIONS, , 1. Which of the following tab has Hyperlink option?, , , , a) Insert b) Data c) Formulas, , 2. Which of the following is the keyboard shortcut to create hyperlink in Excel?, a) Ctl+K b) Ctrl +H c) Ctrl +J, , 3. Which type of Hyperlink contains partial address?, a) Absolute b) Relative c) None of these, , 4. Which of the following references represents linking between workbooks?, a) -AVERAGE(Sheet1!A7, Sheet2!A7), b) =AVERAGE([Book1.xIsx]Sheet !$B$3:$E$3), , c) Both a and b, , B. THEORETICAL QUESTIONS — (SOLVED), 1. What is a hyperlink?, , A: A hyperlink is a coloured and underlined text or a coloured and underlined graphic that you click, to open a file, a location in a file or a web page on the Web., , 2. What is external reference in Excel?, , A: Consolidating data from other workbooks or worksheets is referred to as linking or external, reference. The main benefit of using an Excel external reference is that whenever the referenced, cell(s) in other worksheet changes, the value returned by the external cell reference is automatically, , updated., , 3. How can you change a hyperlink appearance?, , A: Step 1: Select the cell with the hyperlink. Click on Cell Styles drop down menu in the Styles group, of Home tab., Step 2: Right-click Hyperlink and then click Modify, to change the appearance of hyperlink. Style, dialog box will appear., , Step 3: In the Style dialog box that appears, click oe Format. In the Format Cells dialog, switch to, the Font or Fill tab, apply the options of your choice and click OK. For example, you can change, , the font, font style, size and font color., Step 4: The changes will be immediately reflected in the Style dialog. Click OK to save the changes., , —

Page 5 :
Sag, , Excel provides with the feature to share workbook with others., , It allows other users to access the same document and allow them to edit the workbook, simultaneously., , By sharing a workbook, you can keep track of the changes other people make and accept or reject, those changes.