FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A tool/button located in the ribbon that inserts the Sum function to calculate the sum of numbers across rows or down columns.
A
Theme
B
Formula
C
AutoSum
D
Range
Explanation: 

Detailed explanation-1: -AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum. Once you create a formula, you can copy it to other cells instead of typing it over and over.

Detailed explanation-2: -Click on the AutoSum button from the Editing group of the ribbon. Excel will highlight the cells that it is adding up and will apply the SUM formula. Hit Enter to accept the highlighted cells and see the total value of your data.

Detailed explanation-3: -Use AutoSum Select an empty cell directly above or below the range that you want to sum, and on the Home or Formula tabs of the ribbon, click AutoSum > Sum.

Detailed explanation-4: -=SUM(BELOW) adds the numbers in the column below the cell you’re in. =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.

There is 1 question to complete.
Previous
Next