Cell Formatting & Editing (Home)

Question 1

Cut, Copy, Paste

Answer 1

Basic functions to manipulate data.

Where to Find:
Home tab → Clipboard group → Use Cut, Copy, Paste buttons.

Question 2

Paste Special

Answer 2

Paste specific elements like values, formats, etc.

Where to Find:
Home tab → Clipboard group → Click the small arrow under Paste.

Question 3

Format Painter

Answer 3

Copy formatting from one cell to another.

Where to Find:
Home tab → Clipboard group → Click Format Painter.

Question 4

Find & Replace

Answer 4

Search for specific data or replace values.

Where to Find:
Home tab → Editing group → Click Find & Select.

Question 5

Clear Formatting

Answer 5

Clear contents or formatting from selected cells.

Where to Find:
Home tab → Editing group → Click the Clear button.

Question 6

What is AutoFit in Excel?

Answer 6

AutoFit automatically adjusts the column or row size to fit the longest or tallest data in that column or row.

How to use: 1.)        Hover your cursor between column/row headers (e.g., between A and B). 2.)        Double-click when the cursor changes to a double-arrow.
Result: The column/row adjusts to fit the largest content.