Nt1330 Unit 3

Words: 998
Pages: 4

What formula or function does he put in Column F that will show the total expenses for each day?
-Bill should insert the SUM function. As he inserts this function, It will calculate the total amount of expenses for that day as this function takes all the values in the spreadsheet and totals the presented values.

2.⦁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? -The inserted function Bill would use for this category is once again, the SUM function. However, instead of selecting the entire range of values totaled altogether, he would do this column by column. Starting with column B, he would insert SUM(B:1, B:12) the value would be presented in row 13 of B’s column. He
…show more content…
It is imperative that Bill understands what malicious content could potentially do with his computers and his business records if it gains entrance to his software. If this were the case, the dangers include total computer takeover and vital business information lost that he could never again retrieve. To prevent this, It is wise that Bill uses an antivirus software that provides thorough protection to his computer. An example is, if Bill were to use Microsoft Security Essentials as he is using Microsoft for his computer systems. This software contains real time protection as well as a variety of scans that Bill can use from full system, quick and custom scans to ensure he receives the most protection. If he were to choose another antivirus software, he could buy an advanced antivirus software such as Norton. Norton is much like Microsoft Security Essentials in regards to the variety of scans and other similar features if this option is in accordance with his