2.1 Converting and formatting data

spreadsheet cell contains the coldest temperature ever recorded in Austria: -37 degrees Celsius. Which function would convert that to Fahrenheit?

A. =CONVERT (-37, "F", "C")

B. =CONVERT (-37, "C", "F")

C. =CONVERT (-37, C, F)

D. =CONVERT (-37, F, C)

B. =CONVERT (-37, "C", "F")

Fill in the blank: A data professional uses ___ in order to ensure spreadsheet values are static, rather than carrying over a preexisting formula or function.

A. formatting

B. data validation

C. paste values only

D. conditional formatting

C. paste values only

Which data-validation menu option highlights data entry errors to ensure spreadsheet formulas continue to run correctly?

A. Forbid entry

B. Remove validation

C. Reject invalid inputs

D. Deny text

C. Reject invalid inputs

A data analyst selects Format Cells and the option Text Is Exactly Baseball. This changes the color of all the cells that contain the word "Baseball." What spreadsheet tool is the analyst using?

A. Data validation

B. Conditional formatting

C. CONVERT

D. Filtering

B. Conditional formatting