22. Refer to the screenshot below. Which of the following functions, entered in a single cell, can correctly calculate total expenditure for the mentioned items? A B D E 1 O NOWN 5 Items Coffee Candy Apple Milk Quantity 1 3 10 2 s $ $ S Unit Price 20.00 4.00 1.00 3.00 8 48 10 11 12 O -SUMPRODUCT(C4:07, 04:07) -SUMPRODUCT(C4:07. D4:07) =PRODUCT(C4:07, D4:07) =PRODUCT(C4:07 * 04:07) 23. Nancy is creating a spreadsheet to document her sales every day. She is including a chart of her sales to visualize the numbers. What does Nancy need to do in Excel to ensure that, when new sales data is entered into the spreadsheet, the chart will automatically update to include the new sales data? Insert a line chart after selecting the data, then create a table with "Crtl + T." Insert a line chart after selecting the data, then create a table with "Crtl + S." Create a table with "Crtl +T" then insert a line chart when selecting the table. Create a table with "Crtl + S, then insert a line chart when selecting the table. 24. Please refer to the following screenshot. You want to convert the chart on the left-hand side to the one on the right-hand side, with state names along the x-axis rather than in the legend. How can you complete this task? 600 5300 5000 3400 5500 520 SEO S000 4500 CO 4X00 300 0 und 2017 2011 Man 2019 06-01-2018 Start over, being careful to select the source data in the correct order. On the Layout tab, click the Legend button. On the Layout tab, click the Plot Area button, then click the Axes button in the Decin tahlil tho Sinh