A university has one fie containing the following student information: name, cell phone, land ine, street address, birn date, and another file containing al the information on thei transcript-name, courses, grades, and semesters. The universiy data wrangler would the to add one feld to the transonpt fie that would allow the two files to be linked logether. Which of the felds in the student information file would be the best one 10 add to the transcript file to create that linkage? a tand bine number b. Cell phose number cBieth dese d. Suret addres: Tert gualifer: Data growion 4 b. Semikolon c. Cumma Alca, a traveling sales rep, nobced that ther mieage log had several missng values where she had faled to record the distance driven to vist several active accounts and potential customera. Turning in her mileage log with missing values wovd result in not being reimbursed for the mies she drove, so ste decided so plug in the average distance of all her contiplete enthes for each missing value. This approsch to filing in missing data is a. initubon b.econpolutivo cinporsoo dimemoiriog When using the Convert Text to Columns Wizard in Excel, the General selection for specifying the data format will convert a. numeric and date values to numbers, and all remaining values to text b. numeric values to numbers, date values to dates, and all remaining values to text c.all characters to text d, all characters to a general format that is neither numeric nor character in nature In a csv file, commas are used to a. sequence the variables in either ascending or descending order b. instruct the CPU to temporarily pause data input c. segment the various characters into strings of letters, numbers, or special characters d. separate the raw data into fields