38. A field named Difference appears in the PivotTable Fields pane and in the PivotTable, where it displays the difference between the Year 1 and Year 2 fields. What type of field is Difference? a. Data field b. Calculated field c. Expanded field d. Formula field 39. The rows of Jonathan's PivotTable display store details for each quarter. To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area. a. True b. False 40. Which of the following are ways to format the appearance of a slicer? Select all the options that apply. a. Slicer caption b. Slicer size c. Button order d. Slicer style 41. Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3? a. =LEFT(A24,2) b. =RIGHT(A24,2) c. =LOWER(A24) d. =EXTRACT(A24 2) 42. You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors. a. True b. False 43. Henry imported text data, which appeared in all lowercase. To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function. a. True b. False