Key Takeaways Hiding columns or rows sometimes makes the remaining cells easier to...

Transcribed Image Text:

Key Takeaways ● ● ● Hiding columns or rows sometimes makes the remaining cells easier to view all at once. Whenever you open an unfamiliar worksheet, check for hidden columns or rows. Pasting the contents of one worksheet into another, duplicate worksheet is a convenient way to temporarily save an older version of the sheet you're working on. Wrap Text forces text in a cell to fill the cell with multiple lines instead of running long on the right. Test Your Understanding 1. If you select the 2 x 2 block of cells D3:E4 and then go to Format > Hide and Unhide on the Home tab, what determines whether columns D and E? 2. If you select the 2 x 2 block of cells D3: E4 and then go to Format > Hide and Unhide on the Home tab, what would you select to hide rows 3 and 4? 3. If you want to insert a new column after column C in your spreadsheet, which cell or cells should you select as active before choosing Insert > Insert Sheet Columns on the Home tab? Key Takeaways ● ● ● Hiding columns or rows sometimes makes the remaining cells easier to view all at once. Whenever you open an unfamiliar worksheet, check for hidden columns or rows. Pasting the contents of one worksheet into another, duplicate worksheet is a convenient way to temporarily save an older version of the sheet you're working on. Wrap Text forces text in a cell to fill the cell with multiple lines instead of running long on the right. Test Your Understanding 1. If you select the 2 x 2 block of cells D3:E4 and then go to Format > Hide and Unhide on the Home tab, what determines whether columns D and E? 2. If you select the 2 x 2 block of cells D3: E4 and then go to Format > Hide and Unhide on the Home tab, what would you select to hide rows 3 and 4? 3. If you want to insert a new column after column C in your spreadsheet, which cell or cells should you select as active before choosing Insert > Insert Sheet Columns on the Home tab?

Answer rating: 100% (QA)

1 Selecting the 2 x 2 block of cells D3E4 and choosing Forma... View the full answer