## Week 4 – Course challenge

• Select A2-R210, then use the drop-down menu to Sort Sheet by Column K from A to Z
• Use the SORT function syntax: =SORT(A2:R210, 11, TRUE)
• Select A2-R210, then use the drop-down menu to Sort Range by Column K from A to Z
• Use the SORT function syntax: =SORT(A2:R210, K, TRUE)

#### 2. Scenario 1, continuedYou notice that many cells in the city column, Column K, are missing a value. So, you use the zip codes to research the correct cities. Now, you want to add the cities to each donor’s row. However, you are concerned about making a mistake, such as a spelling typo.Fill in the blank: To add drop-down lists to your worksheet with predetermined options for each city name, you decide to use _____.

• VLOOKUP
• the find tool
• data validation
• the LIST function

#### 3. Scenario 1, continuedNow, you decide to address Tayen’s request to include a handwritten note in the direct-mail piece for anyone who gave at least \$100 last year. Which of the following spreadsheet tools will enable you to change how cells appear if they contain a value of \$100 or more?

• Conditional formatting
• The COUNTA function
• The MAX function
• Data validation

• True
• False

• True
• False

• OUTER JOIN
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN

• True
• False

#### 10. Scenario 2, continuedNow that you provided her with the average donation amount, Tayen decides to invite 50 people to the grand opening of a new community garden. You return to your New Donor List spreadsheet to determine how much each donor gave in the past two years. You will use that information to identify the 50 top donors and invite them to the event. What is the correct syntax to add the contribution amounts in cells O2 and P2?

• =SUM(O2*P2)
• =SUM(O2/P2)
• =SUM(“O2,P2”)
• =SUM(O2,P2)

• True
• False

• True
• False

• True
• False

## Shuffle Q/A 1

• =SORT(A2:R210, 11, TRUE)
• =SORT(A2:R210, K, ASC)
• =SORT(A2:R210, K, TRUE)
• =SORT(A2:R210, 11, ASC)

• =LEFT(L2,5)
• =RIGHT(5,L2)
• =LEFT(5,L2)
• =RIGHT(L2,5)