FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Henry wants to consolidate data into the Total Year Miles workbook. He uses the following formula:=Sum(June!B5:August!B5)What is June?

A	the sixth column of the workbook
B	the sheet name in the workbook
C	a relative reference
D	none of the above

Explanation:

Detailed explanation-1: -To create the formula using our sample list above, type =SUMPRODUCT(C2:C5, D2:D5) and press Enter. Each cell in column C is multiplied by its corresponding cell in the same row in column D, and the results are added up.

Detailed explanation-2: -=DATE(year, month, day) The DATE function includes the following arguments: Year – This is a required argument. The value of the year argument can include one to four digits. Excel interprets the year argument according to the date system used by the local computer.

Detailed explanation-3: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Detailed explanation-4: -What is SUMPRODUCT IF? The SUMPRODUCT IF function is a combination of the SUMPRODUCT and IF functions that apply logical expressions to multiple data ranges if some of the data points meet a specific criterion.

There is 1 question to complete.