Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.2 Modify a Table: Insert Total Rows

AutoSum the Hours This timesheet will calculate the daily total. For example, how many hours did you work on Monday?   5. Try it: AutoSum the Data Select Cell A13. Go to Formulas ->AutoSum ->Sum.   What Do You See? The formula in Cell A13 is =SUBTOTAL(109,[Monday])   What Else Do You See? The AutoCorrect options allow you to select the following: Place Formula in Table Total Row Place Formula Inside Table Place Formula Below Table.   Pick Place Formula in Table Total Row. Keep going...   Memo to Self: You may have been expecting a formula that looked like this: =SUM(A2:A12). This is a Table, so the function is different. Formulas ->AutoSum ->Sum