Question 6 an analyst is working on a project involving customers from bogota, colombia. They receive a spreadsheet with 5,000 rows of customer information. What function can they use to confirm that the column for city contains the word bogota exactly 5,000 times? 1 point.

Respuesta :

Where an analyst is working on a project involving customers from Bogota, colombia and they receive a spreadsheet with 5,000 rows of customer information. The  function that can they use to confirm that the column for the city contains the word Bogota exactly 5,000 times is the "COUNTIF Function."

What is the COUNTIF function?

If you want to learn how to count text in Excel, use the function COUNTIF with the criterion set using wildcard *, as in =COUNTIF(range;"*"). The range is the cell range in Excel where you wish to count the text, and wildcard * is the criterion for all text occurrences in the stated range.

In Go. ogle Sheets, the COUNTIF function counts the number of cells in a cell range that fulfill a predefined condition. The function is useful when you want to know how many times a given requirement is satisfied within a range of cells. The COUNTIF function can only test one condition.

Learn more about Spreadsheets:
https://brainly.com/question/8284022
#SPJ1

ACCESS MORE
EDU ACCESS