Excel: Moving and Clearing Cells
5 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

How can you delete a row in Microsoft Excel?

  • Hold any cell in the row, click on the 'Delete' drop-down button, and choose 'Sheet Rows' (correct)
  • Select the row and press the Delete key on the keyboard
  • Double-click on the row number
  • Right-click on the row and choose the 'Delete Row' option
  • What happens when you use the Auto Fill feature in Excel with a source cell containing text or numbers?

  • It changes the format of the destination cells
  • It copies the data from the source cell to the destination cells (correct)
  • It fills a series in the destination cells
  • It deletes the existing data in the destination cells
  • How can you insert a blank row in Excel?

  • Double-click on a row number
  • Hold any cell, click on 'Insert' and choose 'Row' from the menu (correct)
  • Right-click on a cell and select 'Clear Contents' from the menu
  • Press Ctrl+Shift+Plus (+) on the keyboard
  • Which symbol appears when you change a row into a thin black number '4' in Excel?

    <p>A thin black '4'</p> Signup and view all the answers

    What should you do to fill a series when using the Auto Fill feature with numbers?

    <p>Type two consecutive numbers while using Auto Fill</p> Signup and view all the answers

    More Like This

    Excel Inserting and Deleting Cells Quiz
    5 questions
    Removing Cell Style in Excel
    18 questions
    Excel Cell Editing Tips
    10 questions

    Excel Cell Editing Tips

    GratifyingButtercup avatar
    GratifyingButtercup
    Use Quizgecko on...
    Browser
    Browser