is the correct reference for 31. In Excel, to merge cells Al, B1, C1. DI and El. the merged cell. (a) AIEI b) Al (c) El (d) Al-El 32.mm/dd/yyyy is known as (a) a text string (bl a text data fel a data format (d) a number date 33. Excel'sfunction can be used to calculate your monthly mortgage paymentif purchasing a new home. a) PMT (b) IF (c) MIN (d) TODAY 34. When calculating an average. Excel will ignore empty cells. If you want to include those cells in your average calculations, make sure they have a value of (a) s b) void (c) zero (d) null 35. The PMT function is located in which group? (a) Financial. b) Logical. (c) Math & Trig. (d) More Functions. 36. Which of the following is true about an embedded chart? (a) It can be moved elsewhere in the worksheet (b) It can be made larger or smaller (c) It can be deleted (d) All of the above 37. charts work best with data that are organized into rows and columns like a table: (a) column chart. (b) scattergram. (c) ple chart. (d) Line. 38, charts display data horizontally. (a) Pie (b) Box (c) Stacked (d) Bar