Business Consulting

Business Consulting
Name
Institutional Affiliation
Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this:

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? =Sum(B5:E5)
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? =Sum(F5:F11)
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:
Input the word “Yes” in any row in which the total daily expenses are greater than or equal to $100.00. Rows G6 and G9 are yes
If the daily expenses total is less than $100.00, abandon the Column G entry for the row blank. In this case, Row G5,G7,G8,B10, and B11 are all blank.
With Bill’s business expanding, he understands that there is a need to hire more employees, get additional computers for them and provide a room in his house for them. Explain to Bill the network options available, the pros and cons associated with each configuration and the networks required to;
• Make internet connection-Phone companies provide good internet connections with options such as Digital Subscriber Line and Cable connections. There are pros and cons associated with each option (“Infosec – Securing Your Company Network” N.p). The pros of DSL include; fast access to internet…