FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Select ____ from the functions drop-down menu to add a set of numbers.
A
average
B
count
C
max
D
sum
Explanation: 

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 .

There is 1 question to complete.