Content:
Computer- Bill’s business
Name
Institution
Date
Part A
1] The formula to use in F is to use the auto sum sign for cells B5:E5 for the 14th of September and then dragging the bottom left of the cell up to the 20th September.
2] The formula or function suitable in column B through F in row 13 to get the total expenses for the week in each category is Sum (F5:F11), and for a day it is Sum (B5:B12) for the auto/gas category and Sum (E5:E12) for other expenses
3] This is conditional formatting with the logical test being that the daily expense is equal or more than $ 100, this will be rows G 6 and G9 and the formula is represented as IF(F5>=100, “Yes”).
3 b G5, G7.G8, G10 and G11 will be left blank as the daily expenses are below $ 100.
Part B-Configuration of networks
Network configuration is the network str up f
...