Anonymous asked in Computers & InternetProgramming & Design · 4 weeks ago

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 expenses total is less than $100.00, leave the Column G entry for that row blank. Bill’s business is already expanding. He thinks that in a few weeks he will need to hire one or two employees to help him. He knows that each new employee will need their own computer. He is also making the necessary changes so that the new employees will be working in a spare room in Bill’s house. Explain to Bill what networking options he has. Go through each type or configuration of network possible for him, making sure that you explain the pros and cons of each configuration. Finish with your suggestion for the network that he should set up and explain what new hardware will be required to do this. With the possibility of three business computers in his home, and all of his business records possibly vulnerable, this would be a good time to advise Bill on how to set up a routine plan to protect and defend his new network. .

Attachment image

2 Answers

  • VP
    Lv 7
    4 weeks ago

    I wonder if it's SUMthing you should have learned in class?

  • Lujk
    Lv 4
    4 weeks ago

    if this is for some excel certification, you obviously arent certified

Still have questions? Get your answers by asking now.