Question 2Scenario 1 continuedYou’ve downloaded the data from your company database and imported it into a spreadsheet. IMPORTANT: To answer questions using this dataset for the scenario, click the link below and select the “Use Template” button before answering the questions.Link to template: Course Challenge - Scenario 1OR If you don’t have a Google account, you can download the template directly from the attachment below.Course Challenge Dataset - Scenario 1 - Scenario 1_ Pharmacy Data - Part 1CSV FileNow, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing for Store Number 15 in Row 16. Which of the following would be an appropriate response?1 pointSort the spreadsheet so the row with missing data is at the bottom.Ask a colleague on your team how they've handled similar issues in the past.Delete the row with the missing data point.Replace the row with the average values of the other data points.

1.Question 1Download the spreadsheet "Chicagocrimedata (Week 4 quiz).xlsx" below. The file contains statistics on daily crime data in Chicago from 2011 till 2022. It contains the date, average temperatures (in Fahrenheit) and various kinds of offences.Use the data in the "Week 4 quiz - get data" worksheet for the remainder of the assignment.Chicagocrimedata (Week 4 quiz)XLSX FileFill in the columns "assault", and "temp_average" in the worksheet "Week 4 quiz - get data" using the VLOOKUP formula. What is the value in cell C150?

Summary of the raw data collected can also be presented as text.Group of answer choicesTrueFalse

Assuming Mr. Moi only wants a database system that would keep records of medicine{names ofmedicine, amount in grams in stock}, purchase{medicine bought, amount in grams bought, whoattended to customer, when it was sold, contact and name of customer that bought the medicine}a. Draw a normalized ER diagram with only the most important data from question 1 bearing in _mind the information that Mr. Moi wants.

After the administrative details, a CBC Schemes of work has a column for all the following excerpt/(1mark)Question 7Answera.Key Inquiry Questionsb.Specific Learning Outcomesc.Learning Experimentsd.Sub strand

Question 3I want to have records of household information. Which of the following would be information I could record in Excel? (Select all that apply.)1 pointFreezer InventoryDaily activity diary with memoriesHousehold BudgetsCleaning Directions.