Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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()
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started