USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
average
|
|
|
count
|
|
|
max
|
|
|
sum
|
Detailed explanation-1: -2.1) In the Lookup and Sum Type section, select Lookup and sum matched values(s) in row(s) option; 2.2) In the Select Range section, specify the Lookup Value, Output Range as well as the Data table range; 2.3) In the Options section, choose the Return the sum of all matched values option; 2.4) Click OK.
Detailed explanation-2: -For example, if you wanted to find the sum of two drop boxes, you would type “=Dropdown1+Dropdown2” into the field. Click the “OK” button to save the formula.
Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-4: -Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then click Data Validation . On the Settings tab, in the Allow box, click List .