Microsoft Excel 2021365 - Beginner to Advanced - Inserting Shapes and Text Boxes

This video tutorial covers how to insert and format shapes and text boxes in Excel. It begins with an introduction to the insert ribbon and the shapes gallery, followed by using cut out images to enhance worksheets. The tutorial then demonstrates drawing and formatting shapes, aligning and grouping them, and linking shapes to data cells. Finally, it shows how to add and format text boxes for labeling purposes, creating an effective summary sales worksheet.

What is the purpose of the Shapes Gallery in Excel?

• To insert images into a spreadsheet

• To access different categories of shapes for use in a spreadsheet

• To create charts and graphs

• To format text in a spreadsheet

How can cut-out images be used in a summary worksheet?

• To replace data in cells

• To calculate totals automatically

• To add visual interest and enhance the presentation

• To create hyperlinks to other worksheets

What is the shortcut key to duplicate a shape in Excel?

• Ctrl + X

• Ctrl + C

• Ctrl + V

• Ctrl + D

Which tool is used to ensure equal spacing between shapes?

• Arrange Vertically

• Snap to Shape

• Distribute Horizontally

• Align to Grid

How can you link a shape to a cell in Excel?

• By using the Insert tab

• By typing the cell reference directly into the shape

• By dragging the cell onto the shape

• By using the formula bar and typing '=' followed by the cell reference

What is the first step to remove the outline and fill of a text box?

• Right-click the text box and choose Format Shape

• Double-click the text box

• Go to the Home tab

• Select the text box and go to Shape Format

What is the benefit of grouping shapes in Excel?

• To move and format them as a single object

• To change the color of all shapes at once

• To delete them simultaneously

• To automatically align them