a. Axis Titles b. Chart Titles c. Legend

d. Data Labels

18. Which of the following formulas can you use to find the serial number of the date January 1,2017 ? a. = DATEVALUE(1-Jan-2017) b. = DATEVALUE (01/1/2017) c. = DATEVALUE(1st Jan, 2017) d.= DATEVALUE("01/1/2017") 19. Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this? a. =DAY(A1) c. = DATE(DAY(A1)) d. =DATE( "DAY" (Al)) 20. Which type of chart would you create to compare expenses in each department as a percentage of all expenses? a. Column chart b. Line chart c. Pie chait d. Area chart 21. Which of the following chart elements identifies the purpose of a chart? a. Legend b. Gridlines c. Vertical axis d. Chart title 22. Caleb creared a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts? a. Vertical axis title b. Horizontal axis c. Data table d. New data series 23. Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements