Tell Bill how to do the following tasks:

What formula or function does he put in Column F that will show the total expenses for each day?
What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?
Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G to do this:
Print the word “Yes” in any row where the total daily expenses are greater than or equal to $100.00.
If the daily expe

http://www.google.com/search?q=excel+help&oq=excel+help&aqs=chrome..69i57.2075j0j7&sourceid=chrome&ie=UTF-8

what of the following is a proper use of the application netstumbler?

To calculate the total expenses for each day in Column F, Bill can use the SUM function. Here's what he needs to do:

1. Select the cell in Column F where he wants the total expenses to be displayed for the first day.
2. Type "=SUM(" to start the formula.
3. Select the range of cells that contain the expenses for that particular day. For example, if the expenses for that day are in cells B2:B10, he would select those cells.
4. Close the formula with a closing parenthesis ")" and press Enter.

The cell in Column F will now display the total expenses for that day.

To calculate the total expenses for the week in each category in Row 13, Bill can use the SUM function with multiple ranges. Here's what he needs to do:

1. Select the cell in Column B of Row 13 where he wants the total expenses for the week in the first category to be displayed.
2. Type "=SUM(" to start the formula.
3. Select the range of cells that contain the expenses for that category for the week. For example, if the expenses for that category are in cells B2:B8, he would select those cells.
4. Type "+", then select the range of cells for the next category in Column C for the week. Repeat this step for all the categories in columns D, E, and F.
5. Close the formula with a closing parenthesis ")" and press Enter.

The cell in each column of Row 13 will now display the total expenses for the week in each category.

To remind Bill of expenses that require receipts for the accountant, he can put the following formula in Column G:

=IF(F2>=100, "Yes", "")

This formula uses the IF function. Here's what it means:

- IF(F2>=100: Check if the total daily expenses in F2 are greater than or equal to $100.
- "Yes": If the condition is true, display the word "Yes" in Column G.
- "": If the condition is false, display nothing (an empty cell) in Column G.

This formula will print "Yes" in any row where the total daily expenses are greater than or equal to $100, and leave the cell blank otherwise.