21. Please refer to the following screenshot. Which action will select the four highlighted cells and no others? A B C D 1 2. w NP 3 4 5 Hold down Shift, then click the four cells. Hold down Ctrl, then click the four cells Hold down Alt, then click the four cells. There is no way to select only the four cells. 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 C D E 2 NMON Items Coffee Candy Apple Milk Quantity 1 3 10 2 $ $ S $ Unit Price 20.00 4.00 1.00 3.00 48 10 11 12 =SUMPRODUCT(C4:07, 04:07) ESUMPRODUCT(C4:07D4:07) =PRODUCT(C4:C7, 04: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? 1000 500 so SO SO 50 Sone 500 4 201 10 JO @08 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 On the Design tab, click the Switch Row/Column button