FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these formulas totals the values in the Totals cells in columns July through September?A) =SUM(SalesDept[[#TOTALS]:[September]])B) =SUM([July]:[September]])C) =SUM(SalesDept[[July]:[September]])D) =SUM(SalesDept[[#TOTALS], [July]:[September]])
A
A
B
B
C
C
D
D
Explanation: 

Detailed explanation-1: -Use the SUM function to total a column Click on the cell in your table where you want to see the total of the selected cells. Enter =sum( to this selected cell. Now select the range with the numbers you want to total and press Enter on your keyboard. Tip.

Detailed explanation-2: -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-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: -The SUM function in excel adds the numerical values in a range of cells. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. The values supplied to the function can be numbers, cell references or ranges.

There is 1 question to complete.
Previous
Next