Question

1. Switch to the Academic Groups worksheet. In cell A14, use the INDEX function to display the value in the first row and first column of the AcademicGroups table.
2. In cell A17, use the SUMIF function to display the total membership in 2023 for groups with at least 40 members.

H D Office S А Group Name 2 Computing Club Astronomy Society 4 Humanities and English Club 5 Environmental Management Club 6 Communication Studies Club 7 Nursing Club 8 History Club 9 Psychology Association for Students 10 Investigative Forensics Club 11 Accounting and Finance Forum B Type Academic Academic Academic Academic Academic Academic Academic Academic Academic Academic C Activities Field Field Professional Service Professional Service Professional Professional Field Professional Private None Private Public Private None Private Public None E F G 2021 2022 2023 - + 54 8193 37 51 76 47 54 64 45 44 52 30 32 51 44 47 41 48 40 40 29 2 6 23 6 8 10 5 6 13 Largest Academic Club, 2023: 16 2023 membership in large groups:

Answer 1

Answer:

1 Group Name Type Activities Office 2 Computing Club Academic Field Public 3 Astronomy Society Academic Field Private 4 Humanities and English Club Academic Professional None 5 Environmental Management Club Academic Service Private 6 Communication Studies Club Academic Professional Public 7 Nursing Club Academic Service Private 8 History Club Academic Professional None 9 Psychology Association for Students Academic Professional Private 10 Investigative Forensics Club Academic Field Public 11 Accounting and Finance Forum Academic Professional None 2021 2022 2023 + 54 81 93 37 51 76 47 54 64 45 44 52 30 32 51 40 23 10 5 26 8 6 6 5 12 13 Largest Academic Club, 2023: 14 Computing Club 16 2023 membership in large groups: 17377

a.

Answer:

13 Largest Academic Club, 2023: 14 Computing Club 15

Formula:

=INDEX (array, row_num, [col_num])

So here, the formula would be

=INDEX(A2:G11,1,1)

Selecting A2:G11 will automatically give the group name as AcademicGroups,

row_num = 1

col_num = 1

Screenshot:

12 13 Largest Academic Club, 2023: 14 =INDEX(AcademicGroups,1,1) 15

b.

Answer:

16 2023 membership in large groups: 377 18

Formula:

=SUMIF(range, criteria, [sum_range])

So here, the formula would be

= SUMIF(G2:G11,">40")

Selecting G2:G11 will automatically give the group name as AcademicGroups[2023],

range = G2:G11

criteria = ">40"

Here our criteria will be >40, because we need to get the sum of all groups which has more than 40 members

Screenshot:

15 16 2023 membership in large groups: 17 =SUMIF(AcademicGroups[2023],">40") 18

| Ε 2021 2023 + 54 Ε 2022 81 51 54 37 47 1 Group Name 2 Computing Club 3 Astronomy Society 4 Humanities and English Club 5 Environmental Management Club 6 Communication Studies Club 7 Nursing Club 8 History Club 9 Psychology Association for Students 10 Investigative Forensics Club 11 Accounting and Finance Forum BC Type Activities Office Academic Field Public Academic Field Private Academic Professional None Academic Service Private Academic Professional Public Academic Service Private Academic Professional None Academic Professional Private Academic Field Public Academic Professional None 30 32 10 6 8 56 12 13 Largest Academic Club, 2023: 14 =INDEX(AcademicGroups,1,1) 15 16 2023 membership in large groups: 17 | SUMIF(AcademicGroups[2023],">40") 18