[answered] 1. Bill has set up a spreadsheet in Excel that will help hi

1. Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this: A B C D E F G H Bill's Restaurant Supply H 2 Weekly Expense Journal 3 DAILY RECEIPTS 4 DATE AUTOIGAS HOTELS MEALS OTHER TOTAL REQUIRED DESCRIPTION 5 14?Sep 5 27.00 Gas 6 15?Sep 8 120.00 S 46.00 Holiday Inn, San Diego 7 16?Sep 5 23.00 5 14.00 Lunch & dinner EL office supplies 8 17?Sep 5 24.00 Postage Stamps 9 18-Sep \$135.00 Dinner with Susan 8; Bob, ABC Inc. 10 19?Sep 5 32.00 Gas 11 20?Sep 12 13 TOTAL 14 15 15 Tell Bill how to do the following tasks: 0 What formula or function does he put in Column F that will show the total expenses for each day? 0 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? 0 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: a. Print the word ?Yes" in any row where the total daily expenses are greater than or equal to \$100.00. b. If the daily expenses total is less than \$100.00, leave the Column G entry for that row blank.
This text was automatically generated from the attachment. Please refer to the attachment to view this question.
I need help with this spreadsheet question
This question was created from C10+-+Assignment+8 (1) https://www.aceyourstudies.com/file/11882308/C10-Assignment8-1/?focusQaId=10043635

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001001261.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor