The IT managers have asked you to use the data provided in the CCC Security spreadsheet, Ch$10$Ex$01,$ to identify $(1)$ the department reporting the highest number of security incidents and $(2)$ the most prevalent type of intrusion. Use the $$countif$$ function to count the number of security incidents in which the computer system was compromised. Use a memo format to submit a summary of your findings to the IT department.

Attachments

Ch$10$Ex$01.$xlsx

$(14\mathrm{.}96$ KB$)$