Which of the following is not a way to edit a formula in Excel? Press Esc. Which of the following keys is used to toggle through reference types while you enter a formula? F4 Which of the following options guides you through the process of entering functions? Insert Function How does Excel handle the left-aligned text that is too wide for the column in which it appears? It depends on what is in the next cell to the right. Which of the following is evaluated last in the Excel order of operations? Subtraction no bookmarked, confident, or note marked bookmark popover collapsed Question 6 : Consider the following figure: Figure A: The worksheet What formula will you use to calculate the total expenses of Year 1? =SUM(B8:B15) Answer B is correct. In the cell B16, type the formula as =SUM(B8:B15) to calculate the total expenses of Year 1. Answer C is incorrect. In the above scenario, the =AVERAGE(B8:B15) formula is used to calculate the average ...