Next we will add the numbers in column B in the worksheet accompanying Problem. There are several ways to accomplish this operation in Excel. In a cell at the bottom of column B, you can invoke the SUM function by typing =SUM(B2 : B12) . This action should return the value 416. You can also invokethe AUTOSUM function by clicking on AUTOSUMin the Editing group on the Home tab. Use the mouse to select the values to sum in this way, and show that the same result is found by Excel. In the formula bar, verify that AUTOSUM produces the exact same formula as that entered manually.
Problem Enter the values shown in the accompanying worksheet into a blank worksheet. Use Excel’s help facility to learn about Excel’s Sort & Filter operations. Have Excel sort the numbers from smallest to largest.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.