48. Which of the following must you do before you can create a group? Format the range of cells to be grouped. Insert a summary row either above or below the group. Sort the data. Both insert a summary row either above or below the group and sort the data. 49. Which of the following lets you select a chart element? O clicking O double-clicking Otriple-clicking O none of the above 50. Which of the following is not a popular image format used in Excel? o TXT OJPEG O PNG O TIFF 51. Which of the following functions finds the largest value in a range of cells? AVERAGE O MAX O MEDIAN O COUNT 52. When creating a consolidation worksheet what must you do to the range of celis to be consolidated? O copy the contents move the contents O delete the contents O format the contents 53. What would you call the number values located on top of the bars in a column chart? O trendine Odata label O data table O source data