QUESTION 10 You are given a dataset filled with all business students. The data has information on graduation date, program of study, and GPA. What function would you use to identify the number of finance students with a GPA over 3.7? COUNT O FILTER DCOUNT O DMAX QUESTION 11 You want to calculate how many weeks old you are. How would you calculate this in Excel? Assume BIRTHDAY = your birthday in a standard date format. O =(TODAY()-BIRTHDAY)*7 O =(TODAY()-BIRTHDAY)*52 O =(TODAY()-BIRTHDAY)/52 O =(TODAY()-BIRTHDAY)/7QUESTION 10 You are given a dataset filled with all business students. The data has information on graduation date, program of study, and GPA. What function would you use to identify the number of finance students with a GPA over 3.7? COUNT O FILTER DCOUNT O DMAX QUESTION 11 You want to calculate how many weeks old you are. How would you calculate this in Excel? Assume BIRTHDAY = your birthday in a standard date format. O =(TODAY()-BIRTHDAY)*7 O =(TODAY()-BIRTHDAY)*52 O =(TODAY()-BIRTHDAY)/52 O =(TODAY()-BIRTHDAY)/7QUESTION 17 Rank the levels of hardware memory from largest to smallest. 4} Personal Computer 4} Supercomputer Mainframe Server . 0 0 0 Workstation QUESTION 18 What type of data storage processes transactions for data analysis? Backup Operational Translational Archival QUESTION 14 Which of the following functions will help me determine how much money I will have when I retire based on what I am contributing to my 401k? OFVO ONPV() O PV() O PMT()QUESTION 14 Which of the following functions will help me determine how much money I will have when I retire based on what I am contributing to my 401k? OFVO ONPV() O PV() O PMT()