3. You are working on an Excel table and realize that you need to delete a column in the middle of your table and shift the remaining data columns to the left. What is one way to do this? Highlight the cell, then click on the Delete Cells button under the Home ribbon Highlight the column, then click on the Delete Cells button under the Home ribbon. Highlight the column, then click the Delete button on your keyboard. Highlight the column, then click on the Delete Cells button under the Data ribbon. 4. You are valuing an investment that will produce cash flows of $10,000 each year for 15 years. What is the quickest way to enter $10,000 into each of the 15 cells of your table? Type $10,000 into the first cell, then highlight that cell and use your cursor to drag the fill handle through the remaining 14 cells. Type $10,000 into each of the 15 cells. Type $10,000 into the first cell, then copy and paste the value individually into each of the remaining cells. 5. You have three tables in a worksheet in Excel. You need to sort one of the tables numerically, from smallest to largest values. How can you do this? Highlight the worksheet, then click on the Data ribbon and find the Sort & Filter button. Use the Custom Sort to sort from smallest to largest. Highlight the table, then click on the Data ribbon and select Sort A to Z under the Sort & Filter button. Use the copy and paste functions to arrange a new table from smallest to largest values. Highlight the table, then click on the Data ribbon and find the Sort & Filter button. Use the Custom Sort option to sort from smallest to largest