In which three frequency bands does the Cisco Spectrum Expert Wi-Fi tool perform spectrumanalysis? () ["ISM 2.4 GHz","ISM 900 MHz","ISM 5 GHz","public safety 4.9 GHz","GSM 1.9 GHz"]
Network management saves time and money by automating which two tasks? () ["Configuring changes to hardware and software","Monitoring online purchasing","Monitoring user access to storage files","Monitoring and troubleshooting network device"]
投资者对风险和收益的偏好状况与该投资者风险资产组合的最优构成是()。 ["正相关","负相关","无关的","皆有可能"]
违反国家规定,个人非法经营音像制品、电子出版物()张(盒)以上的应予追诉 ["2000","1000","500","200"]
在了解分析程序表(用作风险评估程序)时,某些小型被审计单位一定存在可用于实施分析程序的()财务信息,以支持CPA的审计工作。
书写EXCEL函数公式。
已知在A2:G20内给出了一个职工情况简表,并已建立了条件区,条件区内容如下所示,请根据下述要求写出EXCEL的函数公式:

已知年龄位于单元格C2,统计出性别为“女”且年龄大于40岁或性别为“男”且年龄大于50岁的平均年龄。