Microsoft Excel 2021365 - Beginner to Advanced - Working with Rows and Columns

Microsoft Excel 2021365 - Beginner to Advanced - Working with Rows and Columns

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers essential techniques for managing rows and columns in a spreadsheet. It begins with resizing rows and columns using drag-and-drop and auto-fit features. The tutorial then explores various methods for inserting new rows and columns, including using the contextual menu, ribbon, and keyboard shortcuts. It also demonstrates how to delete rows and columns efficiently, highlighting the 'Go to Special' tool for handling large datasets. Finally, the video explains how to hide and unhide rows and columns, providing tips for managing worksheet visibility without deleting data.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of the 'Go to Special' tool in Excel?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you hide a column in a worksheet without deleting it?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps would you take to unhide all hidden rows and columns in a worksheet?

Evaluate responses using AI:

OFF