I need help figuring out the excel formulas for this assignment.

Christine M. Evans 06/10/16 C10V Introduction to Computers Written Assignment 08 Business Consulting Part A - Formulas. The most efficient way that Bill can add up the total expenses for each day is to highlight the top of the F column and then select the Auto Sum function icon located under the Home tab of the sheet. He can also highlight the column will start by putting the formula =sum(B5:E5) in cell F5. Additionally he can highlight B5 through F5, and select the Auto sum function in the Insert Function tab. Either one will give Bill the same result. He will then copy that formula for each row. He can copy it to each row by one of three ways. The easiest is to hover over the cell with the original formula (F5), click and hold when the mouse turns to a little + on the lower right hand side of the box, and drag it down. That will copy the formula to the destined cells. That will give him the daily totals in column F. In order to get the totals for the week, he would highlight from the first day (B5) down to the weekly total cell (B13) and select on auto sum. That will give him the weekly total for that item. He would then select on B13, and drag the formula over to F13 (which would be his ultimate total). If Bill wanted to be alerted that any daily total was over $100 and needing a receipt, he could put the formula =IF(F5>100,"Yes") in G5, and copy it all of the way down to G11. If he has any problems, I would recommend to select the help function. Part B - Networks Part C - Security Concerns