Excel Inserting and Deleting Cells Quiz
5 Questions
2 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

When inserting cells, what does 'Shift cells down' do?

  • Insert cell below at the current cell location and move others up
  • Insert cell to the left at the current cell location and move others to the top
  • Insert cell to the right at the current cell location and move others to the bottom
  • Insert cell above at the current cell location and move others down (correct)
  • What happens when 'Entire Row' is selected for insertion?

  • Insert entire row above at the current cell location and move others down (correct)
  • Insert entire row to the right at the current cell location and move others to the bottom
  • Insert entire row below at the current cell location and move others up
  • Insert entire row to the left at the current cell location and move others to the top
  • What does 'Shift cells up' do when deleting cells from a worksheet?

  • Delete the cells at the current cell pointer location and move the data to the left
  • Delete the cells at the current cell pointer location and move the data up (correct)
  • Delete the cells at the current cell pointer location and move the data to the right
  • Delete the cells at the current cell pointer location and move the data down
  • What does 'Center (or Middle Align)' do for text alignment?

    <p>Text is centered halfway between the top and bottom of the cell</p> Signup and view all the answers

    What is the default vertical alignment for text in Excel?

    <p>Bottom (or Bottom Align): Text appears at the bottom of the cell</p> Signup and view all the answers

    More Like This

    Excel Essentials
    5 questions

    Excel Essentials

    ReplaceableSloth avatar
    ReplaceableSloth
    Filtering Data in Excel: Lesson 20
    10 questions
    Use Quizgecko on...
    Browser
    Browser