4.To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
1 / 1 point
Correct
The correct AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.
Related Questions & Answers:
- Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data. 1.Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and ... Read more...
- Structured query language (SQL) enables data analysts to communicate with a database. 8.Structured query language (SQL) enables data analysts to communicate with a database. 1 / 1 point True ✓ False CorrectSQL allows ... Read more...
- In the following spreadsheet, where can you find all of the attributes — also known as the observation — of Fayetteville? 2.In the following spreadsheet, where can you find all of the attributes — also known as the observation — of ... Read more...
- What is the process of using facts to guide business strategy? 5. What is the process of using facts to guide business strategy? 1 / 1 point Data-driven decision-making ✓ Data visualization Data ... Read more...
- Which of the following questions make assumptions? Select all that apply. 8. Which of the following questions make assumptions? Select all that apply. 1 / 1 point Keeping employees engaged is ... Read more...
- A metric is a specific type of data that companies use to identify a problem domain. 5. A metric is a specific type of data that companies use to identify a problem domain. 1 / 1 point True ... Read more...
