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]
You can use the ____ button in the Editing group to add a range of numbers.
A
AutoTotal
B
AutoCalculate
C
AutoSum
D
AutoAdd
Explanation: 

Detailed explanation-1: -The AutoSum option can be found in two areas: It is contained in the Editing group of the ribbon, as shown in the first example above. It can also be found under the Formulas tab.

Detailed explanation-2: -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-3: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed.

Detailed explanation-4: -The Auto Sum button is found in two locations in the ribbon menu system. Far right on the Home tab, out here in the Editing group, you’ll see Auto Sum right here. It’s got a little drop arrow associated with it, as well. Notice the keystroke shortcut is alt equal.

There is 1 question to complete.
Previous
Next