Question 4An analyst at a weather station is analyzing data to understand how cloud cover affects temperature in their area. Currently, they have data on temperature in Celsius, but they want to convert this data to Fahrenheit. Which formula should they use to convert a Celsius value in cell G5 to Fahrenheit in another cell?1 point=CONVERT(“F”, “C”, G5)=CONVERT(G5, “F”, “C”)=CONVERT(“C”, “F”, G5)=CONVERT(G5, “C”, “F”)

Question 1A spreadsheet cell contains the coldest temperature ever recorded in Austria: -37 degrees Celsius. Which function would convert that to Fahrenheit? 1 point=CONVERT(-37, F, C)=CONVERT(-37, C, F)=CONVERT(-37, "F", "C")=CONVERT(-37, "C", "F")

Which of the answers in below looks like a correct formula in Excel to convert Celsius column to a Fahrenheit column?Group of answer choices=D2*1.8+32D2=F2*1.8+32D2=D2*1.8+32D2*1.8+32

Which is the correct formula for converting degrees Celsius to degree Fahrenheit

Which is the correct formula for converting degrees Farhrenhiet to degrees Celsius

Given the temperature of the day as Celsius as input. Do convert Celsius into Fahrenheit using the formulae: Fahrenheit = ((celcius*9) /5)+32Input Format:Accept a floating point(double) value for Celsius.Output Format:Print the Fahrenheit value with respect to two decimal places(Example: 23.52F)