Question: Given a data file as follows with the input range A 1 :D 1 1 , criteria range in G 1 :I 1 . The

Given a data file as follows with the input range A1:D11, criteria range in G1:I1. The query is to retrieve records for CIS males with GPAs above 3.0.
NAMEGENDERGPAMAJORGENDERGPAMAJORS1F3.3ACCTS2M2.9ACCTS3M3.4CISS4F3.1ACCTS5M3.6OMS6M2.4CISS7M3.9CISS8F3.2ACCTS9M3OMS10F3.8ACCT
Fill in G2, H2, and I2 to complete the criteria range. Which of the following answer is correct?
answer choices:
a) G2: M H2: >3.0 I2: CIS
b) G2: =B2="M" H2: =C2>3.0 I2: =D2="CIS"
c) G2: =M H2: =>3.0 I2: =CIS
d) G2: =B2="M" H2: =C2>"3.0" I2: =D2="CIS"
e) none of them

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!