📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • ✖

      Question

      How can you freeze both rows and columns in an Excel

      spreadsheet?
      A Use the "Split" command from the "View" tab Correct Answer Incorrect Answer
      B Select the rows and columns to be frozen, then right-click and choose "Freeze Panes" Correct Answer Incorrect Answer
      C Use the "Lock" feature from the "Format" menu Correct Answer Incorrect Answer
      D Press Ctrl + F to freeze both rows and columns Correct Answer Incorrect Answer
      E none of these Correct Answer Incorrect Answer

      Solution

       Select the rows and columns to be frozen, then right-click and choose "Freeze Panes." This option allows you to freeze both rows and columns to keep them visible while scrolling through large datasets in Excel.

      Practice Next
      More Quant Miscellaneous Questions
      ask-question