FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A button on the Ribbon that inserts the Sum function to add long columns or rows of numbers.
A
Average
B
IF Function
C
Formula Bar
D
AutoSum
Explanation: 

Detailed explanation-1: -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.

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: -Now, if you want to sum numbers in several rows and columns at once, select the cells where you want to input the AutoSum formula and click the AutoSum button on the Excel ribbon.

There is 1 question to complete.
Previous
Next