Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analytics For Accounting

Authors: Vernon Richardson

2nd Edition

1260904334, 9781260904338

More Books

Students also viewed these Economics questions

Question

Is a partner an employee with regard to withholding taxes

Answered: 1 week ago