Câu 18: 77-602: MOS: Using Microsoft Office Excel 2007

You work as an Office Assistant for Tech Perfect Inc. You have converted a data range into a data table as shown in the image below:You want to add a total row in the table to calculate the total. The total row will include the sum of the Total First Quarter column. You want to perform this in the easiest and best possible way. Which of the following steps will you take to accomplish the task?

1. A. Click the E9 cell. Select the Auto Sum option in the Function Library group of the Formulas tab.
2. B. Click the E9 cell. Insert the following formula- =E4+E5+E6+E7+E8.
3. C. Select a cell in the table. Select the Total Row option in the Table Style Options group of theDesign tab. — đáp án hiện tại
4. D. Select the data range from E4:E9. Select the Auto Sum option in the Function Library group of the Formulas tab.