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 (B)</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 (D)</p> Signup and view all the answers

More Like This

Excel Essentials
5 questions

Excel Essentials

ReplaceableSloth avatar
ReplaceableSloth
Microsoft Excel Guidelines Quiz
48 questions
Use Quizgecko on...
Browser
Browser