Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, you use the WHERE function. The syntax is: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve the number of donors in each city, sorted high to low, you use the following query: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following tools will enable you to sort your spreadsheet by city (Column K) in ascending order? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The zip codes are in a column called zip_code. What query do you use to select all data from the Donation_Form_List organized by zip code? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To change how cells appear, you use conditional formatting. Then, to highlight cells with a value of at least $100, you choose to format cells if they have a value greater than or equal to 100. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You have performed the calculations for 2019, so now you move on to 2020. To return average contributions in 2020 (contributions_2020), you use the AVG function. You use the following section of a SQL query to find this average and store it in the AvgLineTotal variable: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What SQL function will return all records from the left table and only the matching records from the right? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which SQL query will retrieve the number of donors in each city, sorted high to low? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what clause do you include in your query? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What spreadsheet tool can you use to add a drop-down list with predetermined options for each city name? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which SQL query can be used to calculate the percentage of contributions from prospects? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The correct syntax to count how many donations of $100 or greater appear in Column O is =SUMIF(O2:O210,”>=100″). Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What clause do you add to the following query to sort the donors in each city from high to low? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: To add drop-down lists to your worksheet with predetermined options for each city name, you decide to use _____. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What SQL function do you use to select all data from the Donation_Form_List organized by zip code? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following spreadsheet tools will enable you to change how cells appear if they contain a value of $100 or more? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You start with 2019. To return average contributions in 2019 (contributions_2019), you use the AVG function. What portion of your SQL statement will instruct the database to find this average and store it in the AvgLineTotal variable? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what is the correct query? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following procedures will enable you to change how cells in your spreadsheet appear if they contain a value of $100 or more? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You use a SQL function to instruct the database to combine the two columns into a new column called “address.” The syntax is: JOIN(street_address, ” to “, unit) as address. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To move the 5-digit zip code in cell L2 into its own column, you use the function =LEFT(L2,5). Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You start with 2019. To return average contributions in 2019 (contributions_2019), you use the AVG function. What section of a SQL query will instruct the database to find this average and store it in the AvgLineTotal variable? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What syntax adds the contribution amounts in cells O2 and P2? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst uses the following SQL query to perform basic calculations on their data. Which types of operators is the analyst using in this SQL query? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions