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
This question was answered on: Sep 18, 2020
Buy this answer for only: $15
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)
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Sep 18, 2020EXPERT
GET INSTANT HELP/h4>
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
NEW ASSIGNMENT HELP?
Order New Solution. Quick Turnaround
Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.